Database System ConceptWatch
An international courier, express and parcel Services Company is setting up a package shipping system for customers to ship packages. Whenever a customer wishes to ship a package, they can call the company’s customer service personnel to place a shipment request.
A computer system is needed to track the shipment details of the package. This will enable the company to keep track of their customer’s details, shipment details and to schedule a pick-up of the shipment.
Proposed System Operation
When a customer calls in to place a request for a shipment, the customer’s details, the company’s details (where applicable), the type of shipment request and the estimated cost of shipment are logged into the system by the customer service personnel. The courier company provides express delivery of packages by air, road, rail or ocean and allows customers to track the movement of the package. Each mode of delivery has a variety of services such as:
- Day-specific, door-to-door delivery
- Fast delivery services
- Low cost delivery services
- Handling of dangerous, fragile and temperature sensitive packages
- Easy availability world wide
I have to make ER diagram and for that i need help!