ER Diagram 1

The shipping company has a large number of ships or vessels. Each ship or vessel has a unique registration, a captain, a country of origin, a maximum cargo weight and a home port. All of these ships or vessels transport or carry containers.

To help with the logistical management of transporting goods around the world every shipping container has a unique identification number, a capacity size, colour and type (large, medium, small).

This shipping company only transports a limited set of cargo items or goods. It only transports CARS,
TVS, COMPUTERS, MICROWAVES and MOTORCYCLES.

Each cargo item has an unique cargo identification number. So for example 4 cars in the same container will be considered as ONE cargo item with a unique cargo identification number. A container can contain a mixture of these items - for example CARS, TVS, COMPUTERS.

You do not have to consider how many items are included. This is not required for our simple example.

1: Draw an Entity-Relationship diagram to illustrate the relationships between these objects, showing the attributes of each entity and relationship, underlining the key attribute.


2: Draw a relational schema derived from your diagram.

3: Draw the resulting tables with a few lines of appropriate data.