@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

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

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',36

CREATE TABLE STUDENT(Rollno NUMBER, Name VARCHAR(30), Mark1 NUMBER, Mark2 NUMBER, Mark3 NUMBER, Mark4 NUMBER, Mark5 NUMBER)

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','