Question: Read the given and Draw ER- Q1. Model scenario [Marks: 05] Royal Hospital has many doctors. The Hospital stores information such as Did (identifier), Dname,

 Read the given and Draw ER- Q1. Model scenario [Marks: 05]

Read the given and Draw ER- Q1. Model scenario [Marks: 05] Royal Hospital has many doctors. The Hospital stores information such as Did (identifier), Dname, Address and Degree for a DOCTOR. Some of the doctors have more than one Degree. The information regarding a PATIENT such as Pid (identifier), PName, BirthDate, Age and Address which consists of street, city and country is also stored. Some of the patients can be treated by more than one Doctor. The Hospital records the TreatmentDate, when the patient visits a doctor. Each patient can be assigned to only one room, but some of the rooms may have more than one patient. ROOM details such as RoomID (identifier), Floor No and Room Type are also recorded. There are nurses to manage each room. Each NURSE can manage only a single Room. Each room is managed by a single Nurse. Nurse details such as Nurseld (key) and NurseName are stored. Read the given Draw Q2. Model EER- scenario and [Marks: 05] In a university maintain database about its staff. All STAFF have StaffCode (key), StaffNname and DepartmentName as their attributes. There are different types of Staffs that include FACULTY and ADMIN. Faculty members have special attribute called Specializations whereas Admin staffs have specialized attribute called Expertise. Some staff can work as Faculty as well as Admin

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!