Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Harbour={ idH(pk), country, Hname,location} Ship={idS(pk) , Shipname, captain, capacity} Captain is a surname Capacity={capacity_type(pk) , from_cap, to_cap} For example small from 200-300 Medium 301- 800

Harbour={ idH(pk), country, Hname,location}

Ship={idS(pk) , Shipname, captain, capacity}

Captain is a surname

Capacity={capacity_type(pk) , from_cap, to_cap}

For example small from 200-300

Medium 301- 800

Docked (idD(PK) , harbour, ship, since, till, accepted_by)

Accepted_by is a surname of office worker who registered the visit

please write a query

Show names of captains which are also names of harbour office workers.

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

Advances In Databases And Information Systems 14th East European Conference Adbis 2010 Novi Sad Serbia September 2010 Proceedings Lncs 6295

Authors: Barbara Catania ,Mirjana Ivanovic ,Bernhard Thalheim

2010th Edition

3642155758, 978-3642155758

More Books

Students also viewed these Databases questions

Question

Prepare and properly label figures and tables for written reports.

Answered: 1 week ago