2. The following figure shows an ER schema for a database that can be used to…

2. The following figure shows an ER schema for a database that can 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. Use arrows to specify the relationships. Use descriptive names for foreign keys. Date Timestamp Time SHIP MOVEMENT Longitude Latitude HISTORY Type Tonnage Hull 1 Shame N SHIP SHIP TYPE TYPE (Owner (0) Startdate End date N (1.1) SHIP AT PORT VISIT HOME PORT Continent PORT Name 1 10:02 N IN STATE/COUNTRY Name Prime PORT N ON SEN OCEAN/LAKE