FastForwarding is an international freight forwarding company specializing in ocean container shipping. It provides forwarding services to
Fantastic news! We've Found the answer you've been seeking!
Question:
FastForwarding is an international freight forwarding company specializing in ocean container shipping. It provides forwarding services to companies ("shippers" or Beneficial Cargo Owners) that need cargo moved anywhere in the world connected to ocean container ports.
You will be designing a database for FastForwarding to help them keep track of data for the movement of cargo. To understand the business, interviewed their CEO, Lori Murphy, their IT manager, Joe Nelson, and other key personnel in the company. Below is the summary of key points you discovered during these interviews:
- FastForwarding's headquarters is in Shanghai, and they have offices in Singapore, Los Angeles, New York, London, Rotterdam, and many other locations.
- Each ocean shipment is moved by a single steamship line ("carrier"), which operates one or more container ships and can move many shipments. If the cargo has to be split between multiple carriers due to capacity constraints, then the company tracks each as a separate shipment.
- Cargo is moved inside of standard containers. Each shipment will use one or more containers of cargo, and containers are reused many times for different shipments.
- Each ocean shipment is moved from an origin port to a destination port.
- Each port has different customs rules, such as how duties are calculated, which is based on the country the port is located in. Create an entity-relationship diagram (ERD) given the following Entities and Attributes. Then answer the questions about your ERD below. We highly recommend that you create the ERD in Visual Paradigm before starting the questions. Use "ID" attributes as unique identifiers.
- Shipment Distance
- Carrier ID
- Shipper ID
- Port Country Number
- Carrier Contract Type
- Ships
- Country ID
- Ship Type
- Country Region
- Port Name
- Shipment Revenue
- Carrier Name
- Carriers
- Containers
- Country Dutiable Value
- Shipment Origin
- Shipment Destination
- Ship ID
- Departure Date
- Estimated Arrival Date
- Ship Flag State
- Countries
- Carrier SCAC Code
- Shipment Transit Time
- Port ID
- Container Type
- Carrier Status
- Shipments
- Shippers
- Country Rules of Origin
- Port Latitude
- Port Longitude
- Shipper Name
- Container ID
- Ports
- Country Name
- Shipment ID
-
Related Book For
Posted Date: