dataprocessing
$10-30 USD
Paid on delivery
You are to transform the data set into BCNF and 4NF and document the following:
Assumptions made on the data
All Primary keys, Foreign keys, Surrogate keys, and Candidate keys for your chosen tables
Any Referential Integrity Constraints
Functional and Multivalued dependencies
Determinants
You are required to load the data set into your DBMS and complete the following questions. Your SQL code and DBMS output screenshots are required.
How many cities were reported in the data set?
How many hospitals did not report a Healthcare Associated Infection Score?
How many unique Voluntary non-profit – Private Childrens hospitals offer emergency Services?
Which hospitals do NOT offer emergency services with a Heart Attack Mortality rate greater than 11? Show the hospital name, mortality rate, and confirm they do NOT offer emergency services.
Which counties appear in the results from part d? List the same information as in part d, but include the County.
List the hospitals that appear in part d that contain the following telephone area codes: 773, 312, 212, 646, 917, 213, 323.
List all hospitals and their full address (Street, City, State, Zip Code) on the report from the state of Hawaii (HI).
List the states, in order of best to worst, by mean Readmission rate and display the mean Readmission rate.
Project ID: #7569949
About the project
Awarded to:
Best practices for DB design and Data processing known.. Vast experience with Data migration and Designs..
2 freelancers are bidding on average $23 for this job
I am confident that i can deliver in this having worked with databases before. I am both detailed and result oriented, seeking to meet all specified requirements to the letter. I am committed at what i do and can certa More