Assignment: Database Project
You will be designing and creating a DBMS for the field of Healthcare. You will be creating SQL queries based on common queries that a common end-user would make to a healthcare system. In addition, identify when to use No-SQL. Not only are you building multi-table databases for different components of a healthcare system, but you will also incorporate and create image databases that store real and publicly available health data like cancer images and how databases play a role in building machine learning models.
GitHub
All the files will be stored and organized on GitHub.
Background
The healthcare field has very unique data requirements and processes tons of different types of health information daily. Listed below are some papers that will give a comprehensive background into Health Databases.
A list of minimum Requirements:
1) Build an Entity-Relationship Diagram that incorporates all the different types entities, actions, attributes, connecting lines, and cardinality of data within your DBMS.
2) Based on your ER Diagram, you will then create a Relational Schema that will identify all the components of your table. Be sure you highlight your primary and foreign keys.
3) Create your DBMS within SQL database.
a) Create a database dump of your database and upload that into GitHub.
b) Each table should have no less than 20 tuples. You could potentially have hundreds of tuples if wanted. There are tons of open-source health datasets online that you can scrape your data from instead of making it all up on your own.
4) Create a list of SQL queries and document their output to common queries that an end-user might have about their data. These queries should include areas like:
a) Aggregate Functions
b) Dates
c) SQL Logical Operators like IN, AND, LIKE, NOT, OR, ANY, BETWEEN, EXISTS, etc.
d) Regular Expressions
e) Formula Expressions
f) Subqueries
5) Identify and then develop any and all infrastructure diagrams that will incorporate SQL and No SQL DBMS. Specify why one would be used over (if at all) another in your final report.
a) As part of this section, you will need to identify, define, compare, and contrast the different types of databases. This means you need to identify all the (major) different types of databases available and their uses. You will want to create a Table here. In your final statement you need to specify why you selected a specific type of database, why it meets your needs.
6) Demonstrate and document a DBMS query.
Format your assignment according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.