Question (1): Answer the following questions: 1. Create the table Flights) with
ID: 3833312 • Letter: Q
Question
Question (1): Answer the following questions: 1. Create the table Flights) with the following attributes, data types and constraints Flight no: varchar2 size: 10 Comp no number, size: 7 F date: date Departure ainport: varchar2 size: 20 Amival airport: varchar2 ,size: 20 No seats number, size: 5 Flight no: primary key Flight no comp no F date Departure ainport Amival ainport No seats 12-May-14 Ryadh Dammam 177 112 a 123 133 Ryadh Madina 112 b 334 Dammam 113 13-Jun-14 iMadinah 124 15-Jul 14 Jeddah Ryad 112 c 2. Insert data in the table?Explanation / Answer
Create table Flights
(
Flight_no varchar2(10) PRIMARY KEY,
Comp_no number(7),
F_date date,
Departure_airport varchar2(20),
Arrival_airport varchar2(20),
No_seats number(5)
);
insert into Flights (Flight_no,Comp_no,F_date,Departure_airport,Arrival_airport,No_seats) values('112_a',123,'12-May-14','Riyadh',Dammam',77);
insert into Flights (Flight_no,Comp_no,F_date,Departure_airport,Arrival_airport,No_seats) values('113_a',124,'13-Jun-14','Riyadh',Madina',103);
insert into Flights (Flight_no,Comp_no,F_date,Departure_airport,Arrival_airport,No_seats) values('112_b',334,'12-May-14','Madinah',Dammam',114);
insert into Flights (Flight_no,Comp_no,F_date,Departure_airport,Arrival_airport,No_seats) values('112_c',124,'15-Jul-14','Jeddah','Riyadh',90);
1. desc Flights;
2. Select Departure_airport from Flights;
3. Select * from Flights where Arrival_airport = 'Dammam';
4. Select * from Flights where No_seats > 90;
5. Update Flights set Comp_no = 335 where Comp_no = 334;
6. Delete from Flights where Flight_no = '112_b';
7. Select Flight_no,Departure_airport from Flights where F_date = '13-Jun-14';
8. Rename Column Flights.Flight_no to F_no;
9. Select * from Flights;