67 245
Assignments Done
99,2%
Successfully Done
In November 2018

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

Question #55690
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]
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions