Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ASAP PLS 4. A courier company seeks to build a management system to track mail deliveries or packages of its customers. - The customer must

image text in transcribed

ASAP PLS

4. A courier company seeks to build 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

Students also viewed these Databases questions

Question

Decision Making in Groups Leadership in Meetings

Answered: 1 week ago