DATABASE MANAGEMENT SYASEMS

ASSIGNMENT 

• ASSIGNMENT 1 : 

• Create Table

create table employee

(eid int,

 ename varchar(50),

 grade varchar(2),

 age int,

 gender varchar(2),

 estate varchar(15),

 salary numeric(7,2)

);

• ASSIGNMENT 1 : 

• Create Table

insert into employee values

(101, 'Gautam Sinha', 'A', 40, 'M', 'BH', 50000.00),

(102, 'Srijan Basu', 'B', 30, 'M', 'WB', 40000.00),

(103, 'Nandani Apte', 'A', 45, 'F', 'MH', 57000.00),

(104, 'Satyen Murmu', 'B', 33, 'M', 'JH', 32000.00),

(105, 'Priya Kumari', 'C', 31, 'F', 'JH', 25000.00),

(106, 'Vignesh D', 'D', 25, 'M', 'TN', 15000.00),

(107, 'Grishma Dasari', 'C', 27, 'F', 'AP', 17000.00);