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.
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: https://www.ncbi.nlm.nih.gov/books/NBK236556/
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.
1. Create a database dump of your database and upload that into GitHub.
2. 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:
1. Aggregate Functions
2. Dates
3. SQL Logical Operators like IN, AND, LIKE, NOT, OR, ANY, BETWEEN, EXISTS, etc.
4. Regular Expressions
5. Formula Expressions
6. 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.
1. 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.
Health Data Repositories:
1. National Cancer Institution, Imaging Data Commons: https://portal.imaging.datacommons.cancer.gov/collections/
2. Healthdata.gov: https://healthdata.gov/
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.