Database Answers Header Pier at Cannes
Inventory of Rental Equipment
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 :-
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

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

© IceBreaker WebDesigns 2002