Answer to Question #55690 in Databases | SQL | Oracle | MS Access for bhavin

Question

While analyzing the application, you identify the following entities and their attributes:
Patient:
Patient_ID
Patient_First_Name
Patient_Last_Name
Department_Code
Department_Name
Doctor_Name
Doctor:
Doc_ID
Doc_Name
Doc_Salary
Dept_ID
Dept_Name
Dept_Head
Doc_Fee
Department:
Dept_ID
Dept_Name
Doc_ID
Doc_Name
Dept_Head
Based on these entities and attributes, you create the structure of the table for storing the patient
details, as shown in the following table.
Similarly, you create the structure of the table for storing doctor details, as shown in the following
table.
In addition, you create the structure of the table for storing department details, as shown in the
following table.
1. Analyze the preceding structures of the tables and identify the problems that you may face while
inserting, deleting or updating data in these. Justify your answer. [4 Marks]
2. How can you solve the problems related to the structures of the preceding tables? Justify your
answer. [6 Marks]