wpms
In this project, we developed a database system for a package delivery company. Our product able to manage and maintain related information in a database and support the functionality outlined here.
Design a database system for a worldwide package delivery company (e.g., SMSA, DHL or FedEX). The database must be able to keep track of customers (who ship packages) and customers (who receive packages); some customers may do both. The detailed information of company employees is maintained in the database. The company receives and ships packages and maintains up-to-date information on the processing and current location of each shipped package as follows: • Shipped packages can be characterized by package number (unique), weight, dimensions, insurance amount, destination, and final delivery date. • Each package must be identifiable and trackable, so the database must be able to store the location of the package and its history of locations. • Locations include trucks, planes, airports, and warehouses and are uniquely identifiable. • Shipped packages are received into the system at a single retail center. Retail centers are characterized by their type, unique ID, and address. • Shipped packages make their way to their destination via one or more standard the company transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique schedule number, type (e.g, flight, truck), and the delivery route.
The list of requirements with constraints/business rules are as follows: a) The packages are categorized as Regular, Fragile, Liquid, Chemical etc. b) The status of the packages is as follows in transit, delivered, lost or damaged. c) The value and insurance amount of the package is maintained as well as the payment to the company based on weight as cost for delivering the package. d) Any company employee or customer should be able to search their packages by their ID, category, city and delivery date. e) The movement history including the current place of the package in transit must be produced upon request. f) The system should be able to retrieve information of packages not delivered, damaged or lost. g) The system should identify fines for delayed packages. For lost or damaged packages, the insurance amount is delivered to the customer instead of the package. h) The system should be able to send notifications whenever the packages become available for delivery as well as if they are delayed. i) Each package will have a unique barcode that the system will be able to read.
