NorthStar Air Club. The club maintains a fleet of light airplanes and lets their

Question

NorthStar Air Club. The club maintains a fleet of light airplanes and lets their members fly any airplane based on the membership level. There are three types of memberships:

Basic: 40 hours a year.

Pro: 100 hours a year.

Super: 202 hours a year.

A year runs from January 1st to December 31st. Hours cannot roll over to another year. Members can join or update their membership any time: the hours will be prorated.

It has two departments:

Member services that enrolls members and collects member dues.

Scheduling that keeps track of used hours and assigns aircrafts to members.

Write SQL query to Create a table Scheduling a flight and  updating number of used/remaining hours

Explanation / Answer

SQL query to create table is - Create table tablename ->

Create table SchedulingTable

whenever we want to make any updation then SQL update statement is used

UPDATE SchedulingTable

set remainingHours=2

where flight number= 1;

you define where condition according to question . i have provided you syntax.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.