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.



Powered by WordPress