Topic: Designing a database for Staples, PS delivery, drivers, and customers. PS
ID: 3702032 • Letter: T
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)