CREATE TABLE Airplan
(
AirplaneId INT primary key,
Airplanename varchar(20),
RegisterationID INT ,
Service Date ,
Servicetime INT ,
Member_schedule varchar (20),
Hours INT,
Member_paymentmode varcahr(20),
);
Insert into Airplan Values (’01’,’USAirlines’,’2008′,’05/09/2018′,’8′,’Basic’,’40’,’Credit card’);
Insert into Airplan Values(’02’,’IndiaAirlines’,’9180′,’05/10/2018′,’7′,’Pro’,’100′,’Credit card’);
Insert into Airplan Values(’03’,’SpiritAirlines’,’1870,’05/11/2018′,’5′,’Super’,’202′,’Credit card’);
Insert into Airplan Values(’04’,’DeltaAirlines’,’7390′,’05/12/2018′,’9′,’Basic’,’Cash’);
Insert into Airplan Values(’05’,’BritishAirways’,’9750′,’05/13/2018′,’10’,’Pro’,’202′,’Cash’);
UPDATE Airplan
SET Member_schedule = CASE
When Hours BETWEEN 0 AND 40 THEN ‘Basic’
When Hours BETWEEN 41 AND 100 THEN ‘Pro’
When Hours BETWEEN 101 AND 202 THEN ‘Super’
Please include Primary key and Foreign Key in this table in MSSQL
Expert Answer
An answer will be send to you shortly. . . . .