Help on ER to Relational Schema Mapping and identifying Primary and foreign Keys. I have my answer listed below the ER Schema.

The following figure shows an ER diagram for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema and specify all primary keys and foreign keys.

Date Time stamp Time SHIP_MOVEMENT Longitude Latitude HISTORY Tonnage Hull Sname NTYPE SHIP SHIP TYPE Owner Start date End_date SHIP_AT PORT HOME PORT PORT VISIT Continent Name IN STATE/COUNTRY Pname PORT ON SEA/OCEAN/LAKE Date Time stamp Time SHIP_MOVEMENT Longitude Latitude HISTORY Tonnage Hull Sname NTYPE SHIP SHIP TYPE Owner Start date End_date SHIP_AT PORT HOME PORT PORT VISIT Continent Name IN STATE/COUNTRY Pname PORT ON SEA/OCEAN/LAKE