Using the relational database given in lab work no. 2, write the following queries in SQL: 1) How many different courses are there in each department? Sort the list. 2) How many students do have an advisor in the computer engineering faculty? 3) For each department, find out the highest CGPA of a student. Sort the list. (Add a new column to the student table!) 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. 7) How many different instructors taught the “Computer Programming” course at least two times? 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) ActivitiesO Firefox Web Browser vNoɛ 11 16:02337-Lab_Work-02.pdfO & file:///tmp/mozilla_lampushka0/337-Lab_Work-02.pdf个↓1 of 1+Automatic Zoom>>In this laboratory work, you should investigate how to create a relational database (in a system you have previously installed). That is,you should create all the necessary tables and then insert some data into those tables. The database that you will work on is the universityorganization of our textbook.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)The insertion of data can be in several ways. What are those methods? Which one do you suggest?The student should prepare a report documenting the experimental work done. You may add some screenshots for improving thepresentation of the work. You should also submit the database (.db file) created for inspection.Good luck!::

Note: As per company's given Guidelines we are supposed to answer only first 3-sub parts at time .…

Using the relational database given in lab work no. 2, write the following queries in SQL: 1) How many different courses are there in each department? Sort the list. 2) How many students do have an advisor in the computer engineering faculty? 3) For each department, find out the highest CGPA of a student. Sort the list. (Add a new column to the student table!) 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. 7) How many different instructors taught the “Computer Programming” course at least two times? 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)

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

Using the relational database given in lab work no. 2, write the following queries in SQL:

1) How many different courses are there in each department? Sort the list.
2) How many students do have an advisor in the computer engineering faculty?
3) For each department, find out the highest CGPA of a student. Sort the list. (Add a new column to the student table!)
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.
7) How many different instructors taught the “Computer Programming” course at least two times?
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)

Activities
O Firefox Web Browser v
Noɛ 11 16:02
337-Lab_Work-02.pdf
O & file:///tmp/mozilla_lampushka0/337-Lab_Work-02.pdf
个↓
1 of 1
+
Automatic Zoom
>>
In this laboratory work, you should investigate how to create a relational database (in a system you have previously installed). That is,
you should create all the necessary tables and then insert some data into those tables. The database that you will work on is the university
organization of our textbook.
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)
The insertion of data can be in several ways. What are those methods? Which one do you suggest?
The student should prepare a report documenting the experimental work done. You may add some screenshots for improving the
presentation of the work. You should also submit the database (.db file) created for inspection.
Good luck!
::

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here