Database Answers Header
FACTS for a Database for Club Members

Members of a Fijian Glee Club

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

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001