Need help with Schedule Structure Assignment – Entities and their Relationships.
I’m trying to learn for my MySQL class and I’m stuck. Can you help?
This is not an essay format paper. Please submit a text document and identify ALL entities and their relationships.
Each entity needs to have name, primary key, foreign key, name of parent entity.
Each relationship needs to specify type and business rule.
Read and study the ERD of the STUDENT schema (diagrams available in the ERD directory of the StudentSchema zip file attached). 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: 1:M between Instructor and Section.
Business rules: an instructor can teach zero or many sections; a section will be taught by one and only one instructor.