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)
Using the relational
7) How many different instructors taught the “Computer
8) Which instructor taught the “Object-Oriented Programming” course the most time?
You should also present the output of each query in the lab report.
===========================================
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)
Step by step
Solved in 4 steps