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

write a query

6. Is there any capacity type with no ships of this type _of capaciy ?

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

How To Make A Database In Historical Studies

Authors: Tiago Luis Gil

1st Edition

3030782409, 978-3030782405

More Books

Students also viewed these Databases questions