Using the relational database given in lab work no. 2, write the following queries in SQL:1) Which course titles were given by at least two different instructors during the past?2) Which departments have at least two instructors and at least ten students?3) Which students took COMP117 from Cem Kalyoncu and COMP124 from Zafer Erenel?4) Which students are advised by Soydan Redif and took at least one course from Ezgi Ulker?5) Which students took multiple courses from Zafer Erenel but not a single course from Vesile Evrim?6) For each department, find out the highest salaried instructor name and the highest total credited student name.You should also present the output of each query. ////the database of Lab 2 is on attached file) ActivitiesChromium Web Browser vAEK 10 10:32 D337-Lab_Work-02.pdf - Chromiumn COMP337: Lab Work No. xO 337-Lab_Work-02.pdfn Dashboardо Дай мне огня-YouTube xb My Questions | bartleby x+® File | /home/lampushka/Downloads/337-Lab_Work-02.pdf337-Lab_Work-02.pdf1 / 1200%+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)

Structured Query Language(SQL) A very-high-level language, in which the programmer is able to avoid…

Answered: Using the relational database given in…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

100%

Using the relational database given in lab work no. 2, write the following queries in SQL:
1) Which course titles were given by at least two different instructors during the past?
2) Which departments have at least two instructors and at least ten students?
3) Which students took COMP117 from Cem Kalyoncu and COMP124 from Zafer Erenel?
4) Which students are advised by Soydan Redif and took at least one course from Ezgi Ulker?
5) Which students took multiple courses from Zafer Erenel but not a single course from Vesile Evrim?
6) For each department, find out the highest salaried instructor name and the highest total credited student name.
You should also present the output of each query.

////the database of Lab 2 is on attached file)