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