|
Pls anybody help me with that how to draw ERD diagram (CrowFoot Model) for following case.
Queen Star is a company that rents out heavy duty trucks. Presently, they own 10 trucks. Each truck
is identified by the vehicle registration number. Besides renting out these trucks, the company also owns
10 containers. These containers vary in their load capacity, dimension and function (for example: for dry
cargo or for refrigerated cargo). Each container also has a model number and a unique code used for
administrative purpose.
The company has fifteen employees consisting of 1 manager, 5 clerks, 2 mechanics and 10 drivers.
One of the main responsibilities of a clerk is to manage the booking of the vehicles. When a customer
calls up to make a booking, the clerk will first ask for the customer number or name. If it is the first time
that the customer is making a booking with Muscle Movers, the clerk will ask for the customer’s details for
registration purposes. These details include customer name, business name (if applicable), customer
address, contact number, fax number, and credit card number. When making a booking, the customer
will indicate the booking start date, the booking end date, and the purpose which the truck will be used for.
The purposes can be for: house shifting, business shifting, dry cargo transportation, refrigerated cargo
transportation and rugged terrain transportation. Not every combination of trucks and containers are
suitable for all purposes. Thus the clerk has to go through a list to determine which combinations are
suitable for the specified purpose. Then, the availability of those combinations is checked and the hire
rate of each available combination is presented to the customer. The customer may decide to accept the
hired rate immediately or may call back later with a decision. If the customer calls back later, he/she will
need to provide a booking number previously given by the clerk. Only when the customer has agreed on
the hired rate, the clerk will assign that combination to the booking. A driver with a license type higher or
equivalent to the one required by the truck assigned is then scheduled. If the customer does not call back
with a decision, it is identified as an uncompleted booking. All uncompleted bookings are kept for
administrative purposes.
On every start date, the assigned driver will hook up the allocated truck with the container. Unless the
customer has specified a different meeting address, he will reach the customer address by 8 am sharp.
The truck must be back in the company by 10 pm on the end date. The customer is then charged based
on the following formula:
Number of days booked * (driver hire rate + truck_container hire rate).
The drivers are paid on every fortnight. On top of the basic salary for each employee, each driver is also
paid an additional of 10% * the number of days he has driven within that 2 weeks * driver hire rate.
|
