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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!