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 Clubs
B.2 Club Facilities
B.3 Memberships
B.3 People,('Persons')
C. These THINGS_OF_INTEREST are Related as follows :-
c.1 A CLUB can have zero, one or many FACILITIES
C.2 Each FACILITY can have a separate PRICE.
C.3 A Person can be a MEMBER of zero, one or many CLUBS.
C.4 A MEMBERSHIP is always of a specific MEMBER TYPE.
C.5 A MEMBERSHIP is always of a specific MEMBERSHIP STATUS.
D. Sample Data includes :-
To be determined
E. Typical Enquiries include :-
E.1 How many CLUBS does a MEMBER belong to ?
E.1 How many MEMBERS are there in each CLUB ?
Barry Williams
Principal Consultant
Database Answers
23rd. December 2001
