1. Consider a hospital having several departments (like cardiology, orthopedics, neurology, etc.). Each doctor can belong to only one department. A patient may be admitted under multiple departments and be assigned to one or more doctors. There is a date of admission and a date of release for each patient.
A patient is identified by a patient_id. For each patient, we also need to maintain information like name, address (comprised of house no., street name, pincode and state), gender, date of birth, age and one or more phone numbers. For each doctor, we need to maintain doctor_id , name, date of birth, department and highest degree. A department is identified by its department_code. Other attributes of a department are department name, name of the HoD and number of wards it has.
Draw an Entity-relationship (E-R) diagram for capturing the above-mentioned information, clearly identifying all the entity sets (strong and weak if any), relationship sets, cardinalities, participation and attributes (including the type of attribute like key attribute, multi-valued attribute, derived attribute, etc.). State all assumptions that you make. They should be reasonable.
First draw the ER diagram on the piece of paper provided. Then draw it using the ER-Diagram drawing tool suggested during the lab. Write your roll number and name on the piece of paper.
Submit (a) The piece of paper where you have drawn the ER diagram and (b) a zip file containing the exported output of the ER diagram as well as the image file for it (Name it as Lab2_<Roll_no>_1.zip)
through Moodle for Lab Day 2 Assignment 1.
[Penalty for plagiarism/copying: You will be awarded 0 for all the problems for the lab day and an additional 5 marks will be deducted out of the total of 40 in Lab. All persons involved will be awarded the same penalty irrespective of who has copied from whom]
