Chapter 12. Database Design Case Study 2
East Coast Aquarium
Many-to-many relationships are often the bane of the relational database designer. Sometimes it is not completely clear that you are dealing with that type of relationship. However, failure to recognize the many-to-many relationship can result in serious data integrity problems.
The organization described in this chapter actually needs two databases, the larger of which is replete with many-to-many relationships. In some cases it will be necessary to create additional entities for composite entities to reference merely to ensure data integrity.
Perhaps the biggest challenge with a database design that works for East Coast Aquarium is the lack of complete specifications. As you will see, ...