ERD of TCS Courier service company with cardinality
Answers
Answer:
Explanation:
TCS prides itself on having up-to-date information regarding shipment of items. To do this, TCS relies on a company-wide information system. Shipped items are the main components of the TCS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination and final delivery date. Shipped items are received into the TCS system at a single retail center. Retail centers are characterized by their type, unique ID and address. Shipped items make their way to their destination via one or more standard TCS transportation events (i.e flights, trucks deliveries). These transportation events are characterized by a unique schedule number, a type (i.e flight, truck) and a delivery route. Please create an Entity Relationship Diagram that captures this information about the TCS system. Be certain to indicate identifiers and cardinality constraints. Draw an ERD.