Question
A shipping company has an updated database and information about processing and current location of each shipped item. To keep the database updated the company
A shipping company has an updated database and information about processing and current location of each shipped item. To keep the database updated the company tracks the shipped item. Shipped items can be characterized by item id (unique), weight, dimensions, destination and delivery date. The company has multiple retail centers. Retail centers are characterized by CenterID (unique), type and address. The shipped items reach their destination by transportation route. Transportation routes are characterized by type (flights, trucks, vans etc.), priority, and RouteID (unique).
Create an ERD to capture information about the shipping company. Include identifiers and cardinality constraints
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