What we chose:

3. Database Design In this section describe your database design based on the information and the requirements you described in the previous sections. 3.1. Identification of the entity types and their attributes 3.2. Identification of the relationships and business rules 3.3. Entity Relationships Diagram Describe any assumptions you made. hospital patient 1. Patient_Name 2. Patient_ID 3. status 4. DOB 5. Gender 6. Patient_Address doctor 1. Doctor_Name 2. Doctor_ID 3. specialty 4. DOB 5. Doctor_Salary 6. Doctor_Address nurse 1. Nurse_Name 2. Nurse_ID 3. Nurse_Salary 4. Nurse_Address employee 1. Emp_Name 2. Emp_ID 3. Emp_Salary 4. Emp_Address appointment 1. App_Date 2. App_Time 3. App_Number 4. Depart_Num 5. App_Duration room 1. Room_No 2. Bed_Num 3. Advice_ID 4. Room_location department 1. Depart_Name 2. Depart_location 3. Depart_Num medicine 1. Code 2. Quantity 3. Price medical record 1. Record_ID 2. Date_of_ examination 3. Status