|
Back to the Data Model
A Database is required for a Library of Film Tapes.
B. The Things of Interest, ('THINGS'), to be Tables in the Database, include :-
B.1 Clients.
B.2 Contacts.
B.3 Films.
B.4 Tapes.
C. These THINGS are Related as follows :-
C.1 A Client can have one or many Contacts.
C.2 A Contact is associated with one and only one Customer.
C.3 An Film can have zero,one, or many Tapes.
C.4 A Tape can be one of two Categories
C.5 Each Supplier sells different products.
D. Other Characteristics of these THINGS include :-
D.1 To be determined
E. Sample Data includes :-
E.1 To be determined
F. Typical Enquiries include :-
F.1 To be Determined
That is the end of the Statement of Business Rules.
Barry Williams
17th. July 2008
Principal Consultant
Database Answers
|
  |
|
|