Deliveries

The owner of a small delivery company plans to have an information system that allows him to save data about his customers and deliveries. After some time studying the problem, he reached the following requirements:

Each customer has a VAT number, a name, a phone number and an address.
Customers can send packages to each other. When a package is sent, the company weights the package and generates an identifier for it. Packages must be tagged with either ‘urgent’ or ‘normal’ priority.
The package is then delivered by the customer at the delivery center of his choosing. A delivery center has a unique name and an address.
Each client has an associated delivery center. This delivery center is chosen by the company and it is typically the one closest to the customer’s house.
The package is then routed through an internal system until it reaches the delivery center of the recipient. Every time a package passes through a delivery center, the date of arrival and the date of departure of the package must be saved.
The package is then delivered from the final delivery center to the recipient by a courier.
Couriers have a VAT number, a name and a phone number. Each courier works in a single delivery center.
A courier is assigned to a package as soon as the package is introduced in the system.

Acknowledgement

Credits: André Restivo