Chapter 14
Database Design Case Study #2: East Coast Aquarium
Abstract
This chapter presents the second of three major case studies in the book. It presents a database environment for which two distinct databases that do not share data are an appropriate solution. The larger of the two databases include several many-to-many relationships that must be handled by the design. The case study also includes the use of a CASE tool to provide a prototype user interface for database applications.
Keywords
database design
database case study
ER diagrams
SQL CREATE
prototyping
database prototyping
many-to-many relationships
Many-to-many relationships are often the bane of the relational database designer. Sometimes, it is not completely clear that you are ...
Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
