Consider the following simple scenario of a hospital database that consists of: Departments, Doctors, Patients, and...

 

Transcribed Image Text:

Consider the following simple scenario of a hospital database that consists of: Departments, Doctors, Patients, and Rooms entities. Each Doctor belongs to only one department, each Doctor may have many Patients and each Patient may be treated by many doctors, each room may contain many patients. a) Design a proper RED. (entities, suggested attributes, data types, relationships, cardinality, Primary key) b) Design the Relational DB Schema Consider the following simple scenario of a hospital database that consists of: Departments, Doctors, Patients, and Rooms entities. Each Doctor belongs to only one department, each Doctor may have many Patients and each Patient may be treated by many doctors, each room may contain many patients. a) Design a proper RED. (entities, suggested attributes, data types, relationships, cardinality, Primary key) b) Design the Relational DB Schema