2. The figure below shows an ER diagram 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 ERDPlus to construct the schema Date Time stamp Time SHIP MOVEMENT Longitude Latitude HISTORY onnage Hull Sname SHIP TYPE SHIP TYPE Start date End date 1,1 SHIP_AT PORT HOME PORT PORT VISIT ntinent Name IN STATE/COUNTRY Pname PORT Name ON SEA/OCEAN/LAKE