Answered You can hire a professional tutor to get the answer.
Draw the Entity Relationship Diagram for the following scenario: Truck Services Ltd is an agency involved in the delivery of goods.
Draw the Entity Relationship Diagram for the following scenario:
Truck Services Ltd is an agency involved in the delivery of goods. The drivers who work at the agency are allotted a schedule on a daily basis, which contains information on the various deliveries that need to be done throughout the island. The drivers are then required to get the goods from the supplier and then deliver it to the customer. Each driver normally drives the same truck everyday but can take another one if ever the truck has certain mechanical problem. The details for each truck driver that are recorded are driverID, driverName, and address, contact number (mobile number and home number), the date of birth and age. The age is normally derived from the date of birth. Details for each truck are as follows: platenumber, make, model, year.
The schedule contains the schedule reference number, the product id, the name, description and quantity of products that needs to be delivered, the supplier details and the customer details. The suppliers' details found on the schedule are: supplierID, the suppliers' name, address and phone number. The customers' details are: customerID, customerName, customerPhone(multiple phone number) and customerAddress. A supplier may provide for many products and a customer may receive many products from one or many suppliers. A product is however supplied by only one supplier.
