Database Answers Actors Masks

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
CD Collection - Logical
Back to the Data Model.
This page defines the Business Rules that the Data Model must comply with to support an operational Database.
A. What are the Requirements ?
A.1 We need a Database to record the contents of a CD Collection. 
A.2 The users would like to maintain records for CDs, artist name, tracks, etc..
B. What are the Things of Interest ?
B.1 Artists
B.2 Artists on CDs
B.3 Artists on Tracks
B.4 CDs
B.5 CD Box Sets
B.6 CD Outlets
B.7 CD Tracks
B.8 Record Companies
C. How are they Related ?
C.1 An Artist can appear on zero, one or many CDs.
C.2 A CD can have one or many Artists.
C.3 More Relationships to be established.
D. What else do we know about them ?
D.1 To be determined.

Barry Williams
25th. August 2006
Principal Consultant
Database Answers.org

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map