Topic: Designing a database for Staples, PS delivery, drivers, and customers. PS

Question

Topic: Designing a database for Staples, PS delivery, drivers, and customers.

PS delivery has a delivery contract with Staples, and drivers have a delivery contract with PS delivery. (We want to limit our project scope on the packages being delivered)

1) The package's attributes: a- Physical attributes . b- Pickup location. c-Drop off location. d- Sender. e- Receiver. f-Expected delivery constraints. g-Transport resource. (Record the pickup and delivery time)

Entities: package, location, sender (vendor), receiver (customer), transport(driver)

I am little bit confuse about my attributes (packages, and others stakeholders).

Can you give me some ideas how to deal with my topic?

Thank you

Explanation / Answer

In this delivery management system, you have to manage package delivery.

So, main entities are package, location, sender (vendor), receiver (customer), transport(driver, and vehicle information), order (here we are separating package physical attributes and transportation attributes)

Attributes of each entity:

Package: (PackageID, Description, Weight, IsFragile)

Location: (Street address, city, state, country, zipcode)

Sender: (ID, Name, Address, PhoneNumber)

Receiver: (ID, Name, Address, PhoneNumber)

Transport: (VehicleNumber, DriverName, ContactNumber)

Orders: (ConsignmentNumber, PackageID, SenderID, ReceiverID, VehicleNumber, PickupLocationID, DropLocationID, PickupDateTime, ExpectedDeliveryDate, ActualDeliveryDateTime)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.