@PriyaK

create table Branch
    (Bname VARCHAR(15) NOT NULL,
    City VARCHAR(15),
    Bid NUMBER(4) NOT NULL);
insert into Branch values('Pallavaram','Chennai',106);
insert into Branch values('Green Park','Delhi',408);
insert into Branch values('Pallavaram','Chennai',106);
insert into Branch values('Tambaram','Chennai',104);
insert into Branch values('Bombay','Bombay',405);
insert into Branch values('Chrompet','Chennai',105);

create table Vendors
    (Ven_id INTEGER PRIMARY KEY,
    Ven_name VARCHAR(20) NOT NULL,
    Contact NUMBER NOT NULL,
    Street VARCHAR(20),
    City VARCHAR(20),
    Salary NUMBER,
    Dept_id VARCHAR(10));
alter table Vendors add Dob DATE;
alter table Vendors add Mail_id VARCHAR(20);

create table Employee
    (eno integer PRIMARY KEY,
    ename VARCHAR(20),
    deptname VARCHAR(5),
    salary NUMBER,
    deptno NUMBER);
insert into Employee VALUES(10405,'Karthiga','IT',60000,02);
insert into Employee VALUES(11594,'Ram','MECH',36000,05);
insert into Employee VALUES(37813,'Rajesh','IT',45000,02);
insert into Employee VALUES(42100,'Arthi','CSE',50000,01);

CREATE TABLE STUDENT(Rollno NUMBER,
                     Name VARCHAR(30),
                     Mark1 NUMBER,
                     Mark2 NUMBER,
                     Mark3 NUMBER,
                     Mark4 NUMBER,
                     Mark5 NUMBER);
INSERT INTO STUDENT VALUES(1,'Abinaya',95,87,98,100,94);
INSERT INTO STUDENT VALUES(6,'Sam',79,53,66,45,60);
INSERT INTO STUDENT VALUES(17,'Deepti',94,63,75,75,89);

CREATE TABLE STUDENT
    (Sl_No NUMBER(2),
    Name VARCHAR(20),
    Id NUMBER(10),
    Dept VARCHAR(10));
INSERT INTO STUDENT values('1','Sneha','10045','IT');
INSERT INTO STUDENT values('2','Lavanya','10067','IT');
INSERT INTO STUDENT values('3','Hari','20139','CSE');
INSERT INTO STUDENT values('4','Deepti','30384','MECH');
INSERT INTO STUDENT values('5','Kayal','10628','IT');