4) How many instructors are advising more than three students? 5) Which department has the highest number of students? 6) Which courses have multiple prerequisites? Sort the list.
Using the relational
1)
2)
3)
4) How many instructors are advising more than three students?
5) Which department has the highest number of students?
6) Which courses have multiple prerequisites? Sort the list.
You should also present the output of each query in the lab report.
==========================================
Please dont answer to this :
The relational database schemas are as follows:
department(dept-name, building, budget)
instructor(ID, name, dept-name, salary)
student(ID, name, dept-name, tot-cred)
advisor(s-ID, i-ID)
course(course-id, title, dept-name, credits)
teaches(ID, course-id, sec-id, semester, year)
takes(ID, course-id, sec-id, semester, year, grade)
classroom(building, room-number, capacity)
time-slot(time-slot-id, day, start-time, end-time)
section(course-id, sec-id, semester, year, building, room-number, time-slot-id)
prereq(course-id, prereq-id)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps