|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|