Question: please show how the relationship looks after each step/ foreign key and P key In this assignment, you will take the following ER Diagram and
please show how the relationship looks after each step/ foreign key and P key

In this assignment, you will take the following ER Diagram and convert it to a relational schema. Specify all primary keys and foreign keys. Date Time stamp Time SHIP_MOVEMENT Longitude N Latitude HISTORY 1 Type Tonnage Hull Sname N SHIP TYPE SHIP TYPE Owner (0,9) Start date End_date N (1,1) HOME PORT SHIP AT PORT PORT VISIT Continent 1 (0.9 Name N 1 IN STATE/COUNTRY Pname PORT Name 1 N ON SEA OCEAN/LAKE 1 Assignment: Study the ER diagram for the ship tracking database and convert the diagram into a Relational Model Guidelines on your ER diagram. Follow all ER-to-Relational Model steps Ensure you identify all primary keys and foreign keys. The key to this assignment is following the proper ER-Relational Mapping step by step. Please show how the relational model looks after each step
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
