DBS 651 UMGC ERD Of Student Schema Exercise – Description
Instructions
Read and study the ERD of the STUDENT schema (diagrams available in the ERD directory of the StudentSchema zip file under Hands-on Resources). Refer to schema description if needed (in the data_dictionary directory). Submit a text document to identify all entities and their relationships. For each entity, specify entity name, primary key, and foreign key along with the name of parent entity. For each relationship, specify type of relationship (cardinality) and business rules. For example:
Relationship: “works” between EMPLOYEE and DEPARTMENT
Cardinality: 1:M between DEPARTMENT and EMPLOYEE
Business rule: a department can have zero to many employees; an employee works for one and only one department
The post DBS 651 UMGC ERD Of Student Schema Exercise first appeared on .
