Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Datalog Engines In Databases

Authors: Bas Ketsman ,Paraschos Koutris

1st Edition

1638280428, 978-1638280422

More Books

Students also viewed these Databases questions