Answered step by step
Verified Expert Solution
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
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 Fast please
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started