Question
Construct an Entity Relationship Diagram (ERD) for the scenario as below using CHEN'S NOTATION For each school, we keep track of the unique ID, name,
Construct an Entity Relationship Diagram (ERD) for the scenario as below using CHEN'S NOTATION
For each school, we keep track of the unique ID, name, head, and extension number. For each student category, we keep track of the unique ID and type. We keep track of the unique ID, name, and country for each international student but unique ID and date only for each local student.
Each school has at least one student but can have many students; each student registers under only one school. Each student belongs to one category; each student category can only have many local students or international students but does not have to have any.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started