Question: PLEASE HURRY!! Use the below ER to make the changes requested in the instructions below. Thank you For this lab we will be completing the
For this lab we will be completing the Normalization step for several of your entities from your Lab 2 E/R diagram. After considering my feedback on your Lab 2 E/R diagram, you will normalize the following entities to 3rd normal form - show ALL steps 1st normal form, 2nd normal form and 3rd normal form for each of the following entities PATIENT BED EMPLOYEE DEPARTMENT TREATMENT TEST After going through your steps of normalization - add in your Foreign keys based on your cardinalities from your E/R diagram. You will add new attributes to several of your tables Street Last Name Employee D aty Patient D Date of Birth Name Address Phone number Patient Attended by Employee Belangs to Emal Date Hired Gender Working hn Phone Number Undergoes Tasks Departmert Treatment Code Test Dodor Treatment Description Dept Name Bed Employee Id Patient Bed Num Test description Prescribes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
