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

For each ship and each harbour show the date when the ship arrived there for the first time .

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_2

Step: 3

blur-text-image_3

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

Students also viewed these Databases questions

Question

Identify conflict triggers in yourself and others

Answered: 1 week ago