Why is it not possible to represent N:M relationships with the same strategy used to represent 1:N relationships?
What is an associative entity? What is an association relationship? Give and describe an example of an association relationship other than one. Illustrate your answer using an IE Crow's Foot E-R diagram.
Give and describe an example of a 1:N relationship with an ID-dependent weak entity, other than one shown in the textbook. Illustrate your answer using an IE Crow's Foot E-R diagram.
Create a relational database design for the data model. (Remember that in a database design you cannot have N:M relationships. You must use intersection tables.) For each entity in the E-R model (Illustrate your answer using an IE Crow's Foot E-R diagram), specify a table structureshowing the data types, additional column properties, and identify all primary and foreign keys. Also document referential integrity constraint enforcement actions and any business rules that you think are important.