Answered step by step
Verified Expert Solution
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
For each capacity_type show the name of the ship of the smallest capacity in this type
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started