Database Answers Logo Pier at Cannes
Health Clubs
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  
PURPOSE OF THESE FACTS :-
These FACTS define business requirements which the Database must support.
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 :-
Running a Chain of Health and Fitness Clubs.

B. The Things of Interest, ('THINGS'), include :-
B.1 Classes
B.2 Clubs
B.3 Employees
B.4 Members
B.5 Personal Training Sessions

C. These THINGS_OF_INTEREST are Related as follows :-
C.1 A MEMBER can participate in zero,one or many CLASSES.
C.2 A MEMBER can take PERSONAL_TRAINING with one or many EMPLOYEES.

D. Other Characteristics of these THINGS_OF_INTEREST include
D.1 A MEMBER may or may not have an ADDRESS.
D.2 A MEMBER may join as a FAMILY Member.
D.3 A MEMBER has a Date of Birth and Gender.
D.4 A MEMBER has a PAYMENT_DETAILS.
D.5 A MEMBER has a Date of Birth and Gender.
D.6 An EMPLOYEE has a Date of Birth and Gender.



E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-


G. Design Notes :-



Barry Williams
Principal Consultant
Database Answers
7th. December 2002

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

© DataBaseAnswers.com 2002