Database Answers A Yellow Tape on a Blue Background

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Library of Film Tapes
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
 
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map