Create ERD or EERD of a hospital with these requirements: write DB relational schema draw all foreign key (connect with ---> arrows and underline __ primary key) (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 string entity - locate disjointness Constraints or total contraints (if required) - explain use of Generalization/Specialization Relationship
Create ERD or EERD of a hospital with these requirements: write DB relational schema draw all foreign key (connect with ---> arrows and underline __ primary key)
(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 string entity
- locate disjointness Constraints or total contraints (if required)
- explain use of Generalization/Specialization Relationship
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
