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.

Write a SQL query in MS SQL for  Members (input their information and update it)

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 a SQL query in MS SQL for  Members (input their information and update it)

Explanation / Answer

to create table SQL query to be entered:

create table AirMember(name varchar ,membership_type varchar,dues int,Scheduling int);

as statedin question you want to update details of used hours under scheduling column and oother details can be changed so

query to enter details :

INSERT INTO AirMember(name ,membership ,dues ,Scheduling );

VALUES ('Cardinal', 'basic', 210, 20);

VALUES ('Ram', 'pro', 10, 60);

VALUES ('bela', 'super', 12, 200);

output:

for updating any detail we use update query:

UPDATE AirMember

set membership_type=super

where name = ram;

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

name membership_type dues Scheduling Cardinal basic 210 20 Ram pro 10 60 bela super 12 200

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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