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