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 :-
An e-Commerce Web Site for a specialist Bookseller.
B. The Things of Interest, ('THINGS'), include :-
B.2 Customer Orders
B.3 Customer Rentals
B.5 Other Rental Items
B.6 Rental Items
C. These THINGS_OF_INTEREST are Related as follows :-
C.1 A CUSTOMER can be associated with zero or many VIDEO_RENTALS.
The 'zero' option provides flexibility where a CUSTOMER calls
to place an ORDER for a RENTAL_ITEM, which is subsequently cancelled.
C.2 A CUSTOMER can place zero or many ORDERS for RENTAL_ITEMS.
C.3 A CUSTOMER_ORDER must always be associated with one and only one CUSTOMER.
C.4 A CUSTOMER_RENTAL must always be associated with one and only one CUSTOMER.
C.5 All RENTAL_ITEMS have many attributes in common, and (maybe) some which are not common.
This is shown in the Conceptual Model by an Inheritance relationship between Rental Items
and Videos,Games and 'Other Rental Items'.
D. Other Characteristics of these THINGS_OF_INTEREST include
D.1 A VIDEO_RENTAL has a PRICE for the rent of a Video for a specified period.
E. Sample Data includes :-
To be determined
F. Typical Enquiries include :-
F.1 How many VIDEO_RENTALS are overdue ?
F.2 Do we have any VIDEOS featuring Cher in a Movie ?
G. NOTE :
G.1 The proposed design can easily be implemented with either one Rental Item Table
or separate Tables for Videos, Games, etc..
However, a VIDEOS Table will be preferred if there are many data items are specific
to VIDEOS, and it's often better to avoid an approach which is designed to provide
generality at the expense of ease of understanding.
Database Answers Ltd.
31st. January 2001