1) ABC Courier Company provides fast deliveries of packages. For good services, the company needs to...

 

Transcribed Image Text:

1) 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. [30 marks] 2) For your ER diagram given above, convert it into a relational schema using the mapping guidelines For each relation (table) obtained, specify the name and its attributes, as well as its primary key and foreign key(s). [30 marks] 1) 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. [30 marks] 2) For your ER diagram given above, convert it into a relational schema using the mapping guidelines For each relation (table) obtained, specify the name and its attributes, as well as its primary key and foreign key(s). [30 marks]

Answer rating: 100% (QA)

Unfortunately I am unable to directly visualize images or any other visual content However I can give you a general guide on how you would tackle thes... View the full answer