Create ERD of a hospital with these requirements "and then" write relation schema (underline primary key and connect foreign key with arrow): (use Chen Notation) 1. Hospital have many department, each department have it's own ID, name, and head of department. 2. Hospital need to collect Patient data included : ID, Name, Sexuality, Age, Address, Health Insurance, Telnum 3, Patient may have data stored about people they can contact, should be more than 1 people they can contact 4. Doctor should have : DocID, Name, Sex, TelNum, Specialty, Years of service, Salary, Qualification 5. 1 doctor can be assigned to only 1 department 6. some doctor may not have their assigned patient 7. patient can be assigned to more than 1 doctor f
Create ERD of a hospital with these requirements "and then" write relation schema (underline primary key and connect foreign key with arrow):
(use Chen Notation)
1. Hospital have many department, each department have it's own ID, name, and head of department.
2. Hospital need to collect Patient data included : ID, Name, Sexuality, Age, Address, Health Insurance, Telnum
3, Patient may have data stored about people they can contact, should be more than 1 people they can contact
4. Doctor should have : DocID, Name, Sex, TelNum, Specialty, Years of service, Salary, Qualification
5. 1 doctor can be assigned to only 1 department
6. some doctor may not have their assigned patient
7. patient can be assigned to more than 1 doctor for treatment
8. each treatment shall be stored (date, detail, next appointment)
Specification for the diagram:
- describe what should be describe and what can be describe inside the diagram
- also explain others that can be describe inside the diagram briefly (don't need to be long)
- cardinality ratio, Entity types, keys, attributes, relationship types
- decribe weak entity and strong entity
- locate disjointness Constraints or total contraints (if required)
- explain use of Generalization/Specialization Relationship
Step by step
Solved in 2 steps with 1 images
