Description
Assignment:
Write the following queries in SQL, using the university schema.
1. Create table ‘book-from-library’ using following fields
`BOOK-ID`, `name`, `publication`, `ID`.
Each row in this table is identified by BOOK-ID.
Add an attribute ‘author’
Delete the table
2. (a) Insert a record in the table ‘Student’ with the following values
ID = ‘last 4 digits of your institute roll number’
Name = ‘Your first name’
Dept_name = ‘Comp. Sci.’
Total_credits = 95
(b) Edit the total credits as 90 for the newly added record.
(c) Delete that record.
3. Add 10 credits to all the students in Comp. Sci. department who has total credits less than
100.
4. Display the ID of all the instructors who taught only in 2009
5. Display the toppers in each department
6. Display the courses that are considered as prerequisite courses
7. Display the name & ID of the advisors who advice students from Comp. Sci. department.
8. Display the number of instructors and average salary spend in each department
