Computer Science Question
Question Two
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 of the ABC tracking system, which including: item number (ID), weight, dimensions, destination, and final delivery date.
-
Shipped items are received into the ABC system at a single retail center. Retail centers are characterized by their number, type and address.
-
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.
DETAILED ASSIGNMENT
