Drivers (identified by DRIVER-NO, with each driver having a NAME, one HOME
ADDRESS, and a DATE-OF-BIRTH) take out vehicles to make deliveries. A vehicle
(identified by VEHICLE-NO, with each vehicle being of a particular MAKE and
YEAR-OF-MANUFACTURE) may be taken out of a depot whenever available and kept
out for any length of time (ranging from one or two hours to a number of days.)
It is possible for any vehicle to be taken out more than once on a given day.
Any vehicle can be taken out by any driver any number of times each day. There
is only one depot. Each time a driver takes out a vehicle, he or she takes out
a load made up of any QTY of a number of item types (identified by an ITEM-NO
and having a COLOR, WEIGHT, and DESCRIPTION.) Each time a vehicle is taken out,
the driver can incur expenses of allowed types (eg. fuel cost). Each expense
type has CODE-NO. The AMOUNT and CODE-NO are recorded each time an expense is
incurred. There may be one or more expenses incurred during the same trip. Any
number of stops can be made during the trip. An ADDRESS of the stop is recorded
for each stop, together with the QTY-LEFT of each item type left at the stop.
A driver will stop at an ADDRESS only once during one trip. However, it is possible
for stops to be made at the same address on different trips.
The UPS scenario can be divided into the following two rough areas:
Your group will develop a data model for the UPS scenario by completing the following tasks:
Suggested sequence for constructing the data model: