Deletion of tuples from a given relation
Example:
delete from instructor
where dept_name= ’Finance’
Insertion of new tuples into a given relation
- Add a new tuple to course
insert into course
values (’CS-437’, ’Database Systems’, ’Comp. Sci.’, 4);
- or equivalently
insert into course (course_id, title, dept_name, credits)
values (’CS-437’, ’Database Systems’, ’Comp. Sci.’, 4);
Updating values in some tuples in a given relation
Example:
update instructor
set salary = salary * 1.03
where salary > 100000;