Question: Q 1 . ( 5 0 pts . ) Consider a database with the following scheme: Captain: captainID, name, experience, rating, age Ship: shipID, class,

Q1.(50 pts.) Consider a database with the following scheme:
Captain: captainID, name, experience, rating, age
Ship: shipID, class, model, passengerCapacity, range, flag
Route: routeID, fromCity, toCity, distance
SailTrip: tripID, routeID, shipID, captainID, startDate, endDate, noOfPassangers, income
a.(15 pts.) Write an SQL query to retrieve the following information:
"Find ID, class, and model of ships that has never sailed with full capacity (full capacity means; number of passengers on board is equal to the ship capacity)."
 Q1.(50 pts.) Consider a database with the following scheme: Captain: captainID,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!