Page 1 of 1
instructors (iid integer, name char(20), deptname char(20), salary double) courses (cid integer, title char(20), credit
Posted: Mon Jun 06, 2022 11:21 am
by answerhappygod
- Instructors Iid Integer Name Char 20 Deptname Char 20 Salary Double Courses Cid Integer Title Char 20 Credit 1 (23.65 KiB) Viewed 27 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