Flight-Management-System/insertions_after_normalisation.sql at main · Meharamt/Flight-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
INSERT INTO ADMIN values(001,'CHEEMJU','YAMSHU');

INSERT INTO FLIGHT VALUES(1001, 'AirIndia', 'Delhi', 'Chennai', '01-05-2022 08:00:01','01-05-2022 11:00:00', 100, 7000, 001);
INSERT INTO FLIGHT VALUES(1002, 'JetAirways', 'Delhi', 'Chennai', '08-05-2022 04:00:01','08-05-2022 7:00:00', 200, 5000, 001);
INSERT INTO FLIGHT VALUES(1003, 'AirIndia', 'Mumbai', 'Bengaluru', '06-05-2022 10:00:00','06-05-2022 11:58:00', 300, 9000, 001);
INSERT INTO FLIGHT VALUES(1004, 'Eithad', 'Mumbai', 'Hyderabad', '02-05-2022 9:30:00','02-05-2022 10:40:00', 250, 10000,001);
INSERT INTO FLIGHT VALUES(1005, 'GoAir', 'Bengaluru', 'Chennai', '04-05-2022 01:30:00','04-05-2022 03:00:00', 600, 20000, 001);
INSERT INTO FLIGHT VALUES(1006, 'AirIndia', 'Delhi', 'Mumbai', '18-05-2022 09:00:01','18-05-2022 11:30:01', 150, 6000, 001);


INSERT INTO AIRTIME VALUES('Delhi', 'Chennai', '3 hours 0 minutes');
INSERT INTO AIRTIME VALUES('Delhi', 'Mumbai', '2 hours 30 minutes');
INSERT INTO AIRTIME VALUES('Mumbai', 'Bengaluru', '2 hours 58 minutes');
INSERT INTO AIRTIME VALUES('Mumbai', 'Hyderabad', '1 hours 10 minutes');
INSERT INTO AIRTIME VALUES('Bengaluru', 'Chennai', '1 hours 30 minutes');


INSERT INTO CUSTOMER VALUES(200, 'Vibhav', 'Shukla',DATE '2002-07-15','vshukla_be20@thapar.edu',8851423091,'12345');
INSERT INTO CUSTOMER VALUES(201, 'Yashvardhan', 'Arora',DATE '2001-10-22','yarora_be20@thapar.edu',9625056985,'13579');
INSERT INTO CUSTOMER VALUES(202, 'Nikhil', 'Bakshi',DATE '2001-10-19','nbakshi_be20@thapar.edu',7042320972,'24680');
INSERT INTO CUSTOMER VALUES(203, 'Sidharth', 'Bahl',DATE '2002-04-20','sbahl_be20@thapar.edu',8130664467,'123789');
INSERT INTO CUSTOMER VALUES(204, 'Raghav', 'Sharma',DATE '2002-02-17','rsharma_be20@thapar.edu',9880918485,'456123');


INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(200, 1001, 'VEG' ,1);
INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(201, 1001, 'VEG' ,1);
INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(202, 1002, 'NONVEG' ,1);