instructors (iid integer, name char(20), deptname char(20), salary double) courses (cid integer, title char(20), credit

[answerhappygod]

Instructors Iid Integer Name Char 20 Deptname Char 20 Salary Double Courses Cid Integer Title Char 20 Credit 1 (23.65 KiB) Viewed 25 times

instructors (iid integer, name char(20), deptname char(20), salary double) courses (cid integer, title char(20), credit double) teaching (iid integer, cid integer, year char(20), semester char(10)) lid name deptname 20070101 Jansson CS 9. List the title of courses which contain 'db'. (2 points) Answer: 10. Find the number of tuples in courses relation. (2 points) Answer: 11. If an instructor is from the department of "CS", increase his salary by 200 (using update statement). (2 points) Answer: 12. Delete the tuples in teaching with null value for cid attribute. (2 points) Answer: 13. Drop the table teaching. (1 points) Answer: salary 3000