Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions