PURPOSE OF THESE FACTS :-
These FACTS define the functional requirements which the Database must meet.
They form the basis for agreement between the User and the Database Designer and are
written in a form of structured English which is clear and unambiguous.
The Draft FACTS have been defined and are detailed here ...
A. The Area being Modelled is :-
A Library.
B. The Things of Interest, ('THINGS'), include :-
B.1 Authors
B.2 Books
B.3 Book Categories
B.4 Books Out on Loan
B.5 Users
B.6 User Borrowings
C. These THINGS_OF_INTEREST are Related as follows :-
C.1 An AUTHOR can write many BOOKS.
c.2 A BOOK can have many AUTHORS.
C.3 A BOOK can be in many CATEGORIES.
C.4 A USER can be associated with zero or many BOOKS_OUT_ON_LOAN.
C.5 A BOOK_OUT_ON_LOAN must always be associated with one and only one USER.
E. Sample Data includes :-
To be determined
F. Typical Enquiries include :-
F.1 How many BOOKS are overdue ?
F.2 Do we have any BOOKS by Charles Dickens ?
Barry Williams
Principal Consultant
Database Answers
19th. May 2001
