Available under Creative Commons-ShareAlike 4.0 International License.
- An employee is associated with one spouse, and one spouse is associated with one employee.
- Cannot be implemented as such in the relational model
- M:N relationships can be changed into two 1:M relationships
- Can be implemented by breaking it up to produce a set of 1:M relationships
- Can avoid problems inherent to M:N relationship by creating a composite entity or bridge entity
- A student has many classes and a class can hold many students.
- Implementation of a composite entity
- Yields required M:N to 1:M conversion
- Composite entity table must contain at least the primary keys of original tables
- Linking table contains multiple occurrences of the foreign key values
- Additional attributes may be assigned as needed
- 1247 reads
