Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 02: The following Figure shows an ER schema for a database that may be used to keep track of transport ships and their locations

image text in transcribed

Question 02: The following Figure shows an ER schema for a database that may 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. (14 points) Date Tienestar Time SHIP MOVEMENT Longitude N Latitude HISTORY TRO Tonnage HU 1 SName SHIP TYPE TYPE SHIP StartDate Owner EndDate AN Name VISITS VISITS Continent 1HOME PORT STATE COUNTRY IN Nams PNang PORT N 1 SENOCEAN LAKE ON

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions