(4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships...

   

Transcribed Image Text:

(4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships and their locations for maritime authorities. Map this diagram to a relational schema (SHIP, SHIP TYPE, PORT, PORT_VISIT, SHIP_MOVEMENT, STATE_COUNTRY, SEA_OCEAN_LAKE), and specify all primary keys and foreign keys for each relation. Answer SHIP_MOVEMENT Sname Owner N Phame HOME PORT 1 IN HISTORY 1 SHIP PORT Latitude (0) (0:") Time stamp SHIP AT PORT Longitude N TYPE N N (1,1) IN ON Date Time 1 1 Type Tonnage SHIP TYPE Start date End_date PORT VISIT Name Hull STATE/COUNTRY Name SEA/OCEAN/LAKE Continent (4) [10 pts] Consider the ER diagram for SHIP_TRACKING database to keep track of transport ships and their locations for maritime authorities. Map this diagram to a relational schema (SHIP, SHIP TYPE, PORT, PORT_VISIT, SHIP_MOVEMENT, STATE_COUNTRY, SEA_OCEAN_LAKE), and specify all primary keys and foreign keys for each relation. Answer SHIP_MOVEMENT Sname Owner N Phame HOME PORT 1 IN HISTORY 1 SHIP PORT Latitude (0) (0:") Time stamp SHIP AT PORT Longitude N TYPE N N (1,1) IN ON Date Time 1 1 Type Tonnage SHIP TYPE Start date End_date PORT VISIT Name Hull STATE/COUNTRY Name SEA/OCEAN/LAKE Continent