Suppose that you are having a shipping company called ABC which relies on a wide information system to track the location of each shipped item. The system consists of: Shipped items which are the core...

Suppose that you are having a shipping company called ABC which relies on a wide information system to track the location of each shipped item. The system consists of:

1. Shipped items which are the core of the ABC tracking system, which including: item number (ID), weight, dimensions, destination, and final delivery date.


2. Shipped items are received into the ABC system at a single retail center. Retail centers are characterized by their number, type and address.


3. Shipped items make their way to their destination via one or more standard ABC transportation methods. These transportation methods are characterized by a unique trip ID, a type, and a Delivery Route.

Create an ERD that captures all mentioned information about the ABC system. Be certain to indicate identifiers and cardinality constraints.