Question

UPS relies on an information system. Shipped items are characterized by a unique item number, weight, dimensions, destination, and delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are identified by a unique ID and address. Sending Shipped items to their destination can be made through one or more standard UPS transportations. These transportations are identified by a unique schedule-Number, a type (e.g., flight, truck), and a delivery-Route.

Create an Entity Relationship diagram that captures this information about the UPS delivery system. Make sure to present the constraints.

Answer 1

Solution for creating Entity Relationship Diagram for UPS Delivery System

As per the above given details, the Entities and and attributes of the UPS Delivery System are as follows:

1. Entity: RetailCenter

Attributes: RCenterID, Address

Primary Key: RCenterID

2. Entity: ShippedItems

Attributes: ItemNumber, RCenterID, weight, dimensions, destination, DeliveryDate

Primary Key: ItemNumber

Foreign Key: RCenterID

3. Entity: ItemTransportation

Attributes: ScheduleNumber, ItemNumber, Type, DeliveryRoute

Primary Key: ScheduleNumber

Foreign Key: ItemNumber

ER Diagram

As per the above diagram, a Retail Center may received multiple Shipped Items . Sending items can be made through one or more standard UPS Transportation. Entity RetailsCenter is uniquely identified by RCenterID, Entity ShippedItems by ItemNumber and Entity ItemTransportation is by ScheduleNumber.