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 please show how the relationship looks after each step/ foreign keyand P key In this assignment, you will take the following ER

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!