dataprocessing

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.

Επεξεργασία Δεδομένων Προγραμματισμός Βάσης Δεδομένων Oracle

Ταυτότητα Εργασίας: #7569949

Σχετικά με την εργασία