Scenario: A university has students and courses. Each student can enroll in multiple courses, and each course can have multiple students enrolled in it. What type of entity would you introduce to represent the relationship between students and courses in an ERD?
- Association entity
- Composite entity
- Derived entity
- Intersection entity
In this case, introducing an Intersection entity (or associative entity) is suitable. It represents the many-to-many relationship between students and courses and stores additional attributes related to the enrollment, such as enrollment date or grades.
Loading...
Related Quiz
- What is collaboration in data modeling?
- What is the purpose of generalization in database design?
- What are the key differences between a superclass and a subtype in a Generalization and Specialization hierarchy?
- What measures can be taken at the application level to ensure data integrity in a distributed system?
- What is a subtype in an ERD representing an inheritance hierarchy?