Question

Hello I need to

1. Convert the ER Diagram to a relational model.
2. Analyze each table to make sure that they are in 3rd Normal Form.
3. Write the level of normalization for each table and state in your report why it is an acceptable level of normalization.
4. Physical Database Design: identify the data types of each columns (in each table).

Gender Register Date Name Doctor ID Patient ID Room No Patient Salary qualification Consults Tel No DOB Staff Name Gender Staff (Doctor) Staff ID Position Assign ntmen 0 Patient ID Appointment Examination Date Staff ID Discharge Date Room ID Bed ID Staff ID Decide Patient ID IN Patient OUT Patient Patient ID Waiting List Date Admission Date appointment Date Clinic ID NextOfKin Name Issued To start date Admitted To Bed ID BED quantity Ward ID Medication Drug No finish date Staff ID usage Requested Drug No description Drugs Store cost Drug Name quantity dosage

Answer 1

nno 0. bomln Paliwal ID dimit ID

Dita lian 0 o oa dat