4 airport name in tamilnadu sql select name from

4) AIRPORT NAME IN TAMILNADU
SQL> SELECT NAME FROM AIRPORT WHERE STATE
IN('TAMILNADU');
5) SEAT RESERAVATION DETAILS FOR A GIVEN CUSTOMER NAME AND
DATE
SQL> SELECT * FROM SEAT_RESERVATION WHERE
CUSTOMER_NAME IN('GOKUL')AND DATE1='03-MAR-16';
6) FLIGHT NUMBERS THAT ARE SELECTED ON WEDNESDAY OR
CONTAIN INDIA IN NAME
SQL> SELECT FLIGHT_NUMBER FROM FLIGHT2 WHERE WEEKDAYS
IN('WEDNESDAY');
7) AIRPLANE DETAILS FOR WHICH TYPE IS UNKNOWN
SQL> SELECT * FROM AIRPLANE WHERE AIRPLANE_TYPE IS NULL;
8) FLIGHT LEG DETAILS THAT HAS A DEPARTURE AND ARRIVAL
AIRPORT CODE
SQL> SELECT * FROM FLIGHT_LEGS WHERE
DEPARTURE_AIRPORT_CODE IS NOT NULL AND
ARRIVAL_AIRPORT_CODE IS NOT NULL;
9) AIRPORT DETAILS THAT IS NOT IN CHENNAI
SQL> SELECT * FROM AIRPORT WHERE CITY NOT IN('CHENNAI');
10) SEAT RESERVATION THAT ARE MADE DURING LAST MONTH
SQL> SELECT * FROM SEAT_RESERVATION WHERE
DATE1>'01-AUG-16' AND DATE1<'31-AUG16';
B) ALTER THE TABLES TO:
(1) ADD REQUIRED FOREIGN KEYS
SQL> ALTER TABLE FLIGHT_LEGS ADD CONSTRAINT FK1
FOREIGN KEY(FLIGHT_NUMBER)REFERENCES
FLIGHT2(FLIGHT_NUMBER);
Table altered.
SQL> ALTER TABLE LEG_INSTANCE ADD CONSTRAINT FK2
FOREIGN KEY(FLIGHT_NUMBER,LEG_NUMBER)REFERENCES
FLIGHT_LEGS(FLIGHT_NUMBER,LEG_NUMBER);
Table altered.
SQL>ALTER TABLE LEG_ INSTANCE ADD CONSTRAINT AIRLEG
FOREI GNKEY ( AIRPLANE_ I D) REFERENCES AIRPLANE( AIRPLANE_
ID) ;
Table altered.

SQL>ALTER TABLE CAN_ LAND ADD CONSTRAINT CANAIR
FOREIGNKEY ( AI RPL ANE_ T Y PE_ NAME) REFERENCES AIRPLANE_ T Y
PE( AIRPL ANE_ TYPE_ NAME) ;
table altered.
SQL>ALTER TABLE FARE ADD CONSTRAINT FAREFL IGHT
FOREIGNKEY ( FLIGHT _ NUMBER ) REFERENCES FLIGHT2 ( F LIGHT_
NUMBER ) ;
table altered.
SQL>ALTER TABLE CAN_ L AND ADD CONSTRAINT CANPORT
FOREIGNKEY ( AIRPOR T _ CODE) REFERENCES AIRPORT ( AIRPORT _
CODE) ;
Table altered.
(2) INSERT VALUES TO SEE REFERENTIAL INTEGRITY CONSTRIANTS
SQL> SELECT AMOUNT FROM FARE;
(3) MAKE NAME OF AIRPORT AS UNIQUE AND WEEKDAYS AS NOT NULL
SQL> ALTER TABLE AIRPORT MODIFY(NAME VARCHAR2(20)
UNIQUE); Table altered.
SQL> ALTER TABLE FLIGHT2 MODIFY (WEEKDAYS
VARCHAR2(20) NOT NULL); Table altered .
(4) MAKE WEEKDAYS AS MULTIVALUED ATTRIBUTE
SQL> CREATE TABLE WEEKDAYS(FLIGHT_NUMBER
NUMBER(10),WEEKDAYS VARCHAR2(10),FOREIGN
KEY(FLIGHT_NUMBER) REFERENCES FLIGHT2(FLIGHT_NUMBER)); Table
created
(5) INCREASE THE SIZE OF FLIGHT AIRLINE
SQL> ALTER TABLE FLIGHT2 MODIFY (AIRLINE
VARCHAR2(30)); Table altered.
(6) CONVERT FARE AMOUNT TO DECIMAL TYPE
SQL> ALTER TABLE FARE MODIFY AMOUNT DECIMAL(10);
Table altered.
(7) DECREASE THE SIZE OF FARE RESTRICTIONS
SQL> ALTER TABLE FARE MODIFY(RESTRICTIONS
VARCHAR2(25)); Table altered.
(8) ADD COLUMN COUNTRY IN AIRPORT TABLE
SQL> ALTER TABLE AIRPORT ADD COUNTRY VARCHAR2(20);
Table altered.
(9) ADD A COLUMN ADDRESS IN SEAT RESERVATION
SQL> ALTER TABLE SEAT_RESERVATION ADD ADDRESS
VARCHAR2(50); Table altered.

(10) DELETE THE COLUMN ADDRESS IN Q.9
SQL> ALTER TABLE SEAT_RESERVATION DROP COLUMN
ADDRESS; Table altered.