DROP TABLE COURSE;
DROP TABLE FACULTY;
DROP TABLE STUDENTS;

CREATE TABLE COURSE(CID NUMBER, CNAME VARCHAR(20));
INSERT INTO COURSE VALUES (10,'SQL');
INSERT INTO COURSE VALUES (20,'JAVA');
INSERT INTO COURSE VALUES (30,'UNIX');


CREATE TABLE STUDENTS(SID NUMBER, 
SNAME VARCHAR(20), CID NUMBER);

INSERT INTO STUDENTS
VALUES (1,'Steven',20);


INSERT INTO STUDENTS
VALUES (2,'Neena',10);

INSERT INTO STUDENTS
VALUES (3,'Lex',null);

CREATE TABLE FACULtY
(FID NUMBER,FNAME VARCHAR(20),CID NUMBER);

INSERT INTO FACULTY VALUES (1,'Dinesh',10);
INSERT INTO FACULTY VALUES (2,'Mahesh',30);
INSERT INTO FACULTY VALUES (3,'Sai',20);

COMMIT;

CLEAR SCREEN;
SELECT * FROM STUDENTS;
SELECT * FROM COURSE;
SELECT * FROM FACULTY;