please follow the instructions given to answer the question! thank you

IE4425 Internal Design, "Other Data Models" HW Due Tue 4/5/22 by end of day (submit to Moodle). To be worked individually. 110pts total. 1. [20pts] Develop the full internal design for the admits table in the following ERD; document with a data dictionary. Note that patient data will be frequently filtered and sorted by name, triage priority, or time in. Doctors PK Doctorid DoctorName Admits DoctorCell PK Patient Name Age Gender Assigned Bed Assigned Nurses Triage Priority Timeln Patient FK Doctor PK Nurse