ABC Courier Company provides fast deliveries of packages. For good services, the company needs to have its up-to-date information on the processing and current location of each package. When a customer (e.g. Peter) requires a delivery service, Peter brings a package at a service centre. Then, Peter provides his name, service mode (i.e. fast, regular) and mobile number. Packages can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Also, he pays a fee based on the service mode and the weight of his package. The service centres are characterized by their types, unique centre numbers, and addresses. Packages make their way to their destination one or more transportation arrangements (i.e., train, van, truck deliveries). These transportation arrangements are characterized by a unique shipNumber, a type (e.g, train, van, truck), and a completion timestamp. Design an ER schema for this application, stating any extra assumptions you have like to make
Question
ABC Courier Company provides fast deliveries of packages. For good services, the company needs to have its up-to-date information on the processing and current location of each package. When a customer (e.g. Peter) requires a delivery service, Peter brings a package at a service centre. Then, Peter provides his name, service mode (i.e. fast, regular) and mobile number. Packages can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Also, he pays a fee based on the service mode and the weight of his package. The service centres are characterized by their types, unique centre numbers, and addresses. Packages make their way to their destination one or more transportation arrangements (i.e., train, van, truck deliveries). These transportation arrangements are characterized by a unique shipNumber, a type (e.g, train, van, truck), and a completion timestamp. Design an ER schema for this application, stating any extra assumptions you have like to make
Solution
To design an ER (Entity-Relationship) schema for this application, we need to identify the entities, attributes, and relationships.
Entities:
- Customer
- Package
- Service Centre
- Transportation
Attributes:
- Customer: Name, Mobile Number, Service Mode
- Package: Item Number (unique), Weight, Dimensions, Insurance Amount, Destination, Final Delivery Date, Fee
- Service Centre: Centre Number (unique), Address, Type
- Transportation: Ship Number (unique), Type, Completion Timestamp
Relationships:
- A Customer can have multiple Packages but a Package is associated with only one Customer.
- A Package can be associated with multiple Transportations but a Transportation is associated with only one Package.
- A Service Centre can have multiple Packages but a Package is associated with only one Service Centre.
Assumptions:
- A package once delivered cannot be returned back to the service centre.
- The fee for the package is calculated based on the service mode and weight of the package only.
- The transportation type does not affect the fee of the package.
- The completion timestamp for transportation indicates the time when the transportation of the package was completed.
This is a basic ER schema design for the application. Depending on the complexity and requirements of the application, the schema can be further normalized and optimized.
Similar Questions
Recall the On the Spot courier service introduced in Chapter 2 (Week 2 Tutorial case study). The details of the package pickup and delivery process are described here. When Bill got an order, only on his phone at first, he recorded when he received the call and when the shipment would be ready for pickup. Sometimes, customers wanted immediate pickup; sometimes, they were calling to schedule a later time in the day for pickup. Once he arrived at the pickup location, Bill collected the packages. It was not uncommon for the customer to have several packages for delivery. In addition to the name and address of the delivery location, he also recorded the time of pickup. He noted the desired delivery time, the location of the delivery, and the weight of the package to determine the courier cost. When he picked up the package, he printed out a label with his portable printer that he kept in the delivery van. At first, Bill required customers to pay at the time of pickup, but he soon discovered that there were some regular customers who preferred to receive a monthly bill for all their shipments. He wanted to be able to accommodate those customers. Bills were due and payable upon receipt. To help keep track of all the packages, Bill decided that he needed to scan each package as it was sorted in the warehouse. This would enable him to keep good control of his packages and avoid loss or delays. 4/4 ITECH2002 - Systems Modelling The delivery of a package was fairly simple. Upon delivery, he would record information about when the delivery was made and who received it. Because some of the packages were valuable, it was necessary in those instances to have someone sign for the package upon delivery. Question 8. From this description as well as the information from Chapter 2 (week 2 tutorial case study), identify all the actors who will be using the system. Question 9. Using the actors who you identified in question 9, develop a list of use cases based on the user goal technique. Draw a use case diagram for these use cases. Question 10. Using the event decomposition technique for each event you identify in the description here, name the event, state the type of event, and name the resulting use case
Indicate the advantages that may occur at Coles Distribution Centre by using ABC in relation to the activities of the supply chain process.
What does the term "shipping fulfillment" refer to in eCommerce
Customers prefer to have goods ............... to their doorsteps rather than having to leave their home and travelling to the store.deliveringdeliverdelivereddeliverer
Distribution Logistics are concerned withQuestion 4Answera.make or buy decisionsb.supplier managementc.orderingd.Delivery of finished goods
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.