|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 :-
Inventory of (Offshore Drilling) Rental Equipment.
B. The Things of Interest, ('THINGS'), include :-
B.1 Bills
B.2 Customers
B.3 Employees
B.4 Inventory
B.5 Orders for Maintenance/Repair
B.6 Payrolls
B.7 Transportation Order
C. These THINGS_OF_INTEREST are Related as follows :-
C.1 An EMPLOYEE can have zero,one or many MAINTENANCE_SKILLS.
C.2 An INVENTORY_ITEM has a MAINTENANCE_SCHEDULE that depends on its ITEM_TYPE.
C.3 A Maintenance Task on a MAINTENANCE_SCHEDULE has associated required MAINTENANCE_SKILLS.
D. Other Characteristics of these THINGS_OF_INTEREST include
D.1 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
31st. January 2001
|