Write a query to output the names of all captains

Assignment Help Computer Engineering

Reference no: EM132168449

Using the following tables, you will write a relational algebra expression for each question.

CAPTAINS(CaptainID, CaptainName, CaptainPhone, YearsExperience, CaptainSupervisorID)

CREW(CrewID, CrewName, CrewPhone, DateHired, Position)

BOATS(BoatID, BoatName, SeatingCapacity, HomeHarbor)

TRIPS(TripID, TripDate, TripTime, TripOrigination, TripDestination, TripBoatID, CaptainID)

ASSIGNED_CREW(CrewID, TripID, Payment)

The CaptainSupervisorID matches a CaptainID of another captain.

E. Write a query to output the name of all crew members and their average payment.

F. Write a query to output the name of all captains who have captained every boat.

G. Write a query to output the names of all captains who have captained a boat with a home harbor of Gloucester.

H. Write a query to output the sum of all payments made to crew members on trip 87.

I. Write a query to output the CrewID of all crew members who have never been assigned.

J. Write a query to print, for each tripID, the number of crew members assigned to that trip

Reference no: EM132168449

Questions Cloud

Innovators is one of the wavemakers category : Innovators is one of the wavemakers category? Please describe, innovators, and give example. how does its role in solution economy today?

Using the euclidean algorithm find the decipherment key : Using the Euclidean Algorithm find the decipherment key, d, when p =53 and q=61 and the encryption exponent.

How do the values of organizational behavior : How do the values of Organizational Behavior impact an individual's job?

Calculates the wind chill temperature : Write a script file that does the following operations. Using the MATLAB built-in function plot function, plot Twc (in red colour) for o 32 F Ta ?

Write a query to output the names of all captains : Write a query to output the names of all captains who have captained a boat with a home harbor of Gloucester.

Renovation of a facility : Explain budget planning and cost estimates that will need to be considered for Disaster management to incorporate in the renovation of a facility.

Immediate competitors are adding efficiency to our society : The market has decided that Uber and its immediate competitors are adding efficiency to our society. How is Uber providing the added efficiency?

Write a function that does all the setup of timer : Write a function called "drive". Pass it a parameter that controls whether the bot drives forward, backward, left, right or stops.

Food delivery service such as a pizza business : What can be one of the different types of information technologies that could be used in a food delivery service such as a pizza business?

User Account

All Pages