Reference no: EM131728208
Submit a complete set of 1NF, 2NF, and 3NF tables (ensure you label and identify 1NF, 2NF and 3NF tables). Ensure a complete set of tables (and fields) are included for each normal form (repeat the same table if appropriate, I expect to see a complete set of tables for each normal form level)
5) MS Access database, including the data provided, using only the 3NF tables. Name your database Last Name_CaseStudy (i.e. Smith_CaseStudy). Upload the database to the assignment area as one of the deliverables.
6) Query (In MS Access) that may include one or more tables, as needed, that provides the results for the following request: List each NurseID, their last name, degree, and the H-ID and City where they are employed. Sort the results by NurseID (Ascending) and then by H-ID (Descending values)
7) Create one Form: New Hospital Input - this form should include all relevant fields needed (In MS Access)
8) Create One Report: Hospital List - this report should include any relevant fields that you think might be needed (In MS Access)