Insert
insert into Student (C_No, R_No, Name, Score, Cat, Gender, Add)
values (‘C04’, ‘kalpana’, 58, ‘SC’ ,‘f’, ‘KARAD’);
insert into Staff(Staff_No, Staff_Nm, C_No, Join_Dt, Salary, Post)
values (‘T-005’, ‘Thorat S.A.’, ‘104’, 8-7-03, 10000, ‘lecturer’);
insert into Course( C_No, C_Nm, Est_Dt, Intake, HOD, Current_Add)
values(‘C01’, ‘CIVIL’, 1-1-60, 60, ‘t-003’, 48);
insert into Laboratory(Lab_No, C_No, Name, Non-Tech-Incharge, Cost)
values(0260, ‘A05’, ‘JAVA’, N-033, 15, 0000);
insert into Subject(C_No, Sub_No, Title, Sem_No, Termwork, Theory-Marks, Staff-
Incharge)
values(‘E03’, ‘3-200’, ‘AC-Machine’, 3, 25,100,125,T-006);
insert into Library(C_No, Book_No, Title, Author_Nm, Price, Publication, Sub_No,)
values(‘M01’, 420310, ‘Engg. Drawing’, ‘[Link]’, 600, TMH, 02-655)
Delete
Delete from Student
Where C_No= ‘C04’
Delete from Course
Where Course_Name= ‘MCA’
Delete from Staff
Where Staff_No = ‘N-020’
Delete from Laboratory
Where C_No = ‘E03’
Delete from Subject
Where Book_No = ‘400395’
Update
Update Student
SET Name= ‘kalpana’
Address = ‘karad’
Where Roll_No = 56;
Update Course
SET Est_Date = ‘1-12-1965’
Where C_No = C01;
Update Staff
SET Salary = 20000
Post = ‘HOD’
Where S_No = ‘T-005’;
Update Lab
SET L_Name = ‘Graphics_Lab’
Where L_No = ‘0014’
C_No = ‘C05’;
Update Subject
SET S_No = 04-433
Where C_No = ‘C04’
S_Title = ‘UNIX’;
Update Library
SET Price = ‘$95’
Where B_No = 50010;
Update Staff
SET C_No = ‘C03’
Where S_No= ‘N-221’;
Update Lab
SET COST = 210000
Where L_No = 1;
Update Library
SET TITLE = ‘Comp. Net’
Where Sub_No = 667;
Update Subject
SET SUBTITLE = ‘JAVA’
Where S_No = ‘5600’;
Update Student
SET Name = ‘SEEMA’
Where R_No= 45;
Update Course
SET CURADD=70
Where C_No = ‘C01’
