Database Answers Header
FACTS for a Database for Club Members

Members of a Fijian Glee Club

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