Information Modeling and Relational Databases, 2nd Edition

5.4. Case Study: A Compact Disc Retailer

The following small case study is designed to consolidate the main ideas in CSDP steps 1-5. To derive maximum benefit from it, you should attempt to solve the problem yourself before looking at the solution. The business domain concerns a compact disc (CD) retailer who uses an information system to help with account and stock control, and to provide a specialized service to customers seeking information about specific musical compositions and artists.

Figure 5.32 illustrates the kind of musical information required for compact discs (some of the data is fictitious). Each disc contains several individual musical items, referred to as “tracks”. Although compact discs usually have about 20 tracks, for this ...