Question: Database Design and administration Fast please 4. A courier company secks to beiild a management system to track mail deliveries or packages of its customers.

Database Design and administration
Fast please
Database Design and administrationFast please 4. A courier company secks to beiild

4. A courier company secks to beiild a management system to track mail deliveries or packages of its customers. - The customer must be registered in the system. The customer characteristics that are stored in this system are as following: personal identification number, name, surname, date of birth, address (serves for returning the shipment if the process is unsuccessful), email and phone number. - To each customer a card is issued which is identified by a number and its type such as: Silver, Gold or Platinum. - The package that the customer wants to send is identified by a unique number, date and time of departure (the moment when the company receives it) as well as the characteristics of the package such as: weight and dimensions (length, width and height). - The package must be delivered to the recipient by hand from a postman. The postman is identified by his personal number, name, surname and date of birth, email and phone number. - For each shipment, the system should keep track of the postman in charge for delivery, the status of delivery (delivered successfully or not) and the data and time of delivery

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!