Question
Please solve each question with - tuple query, relational query and domain query 1. Find the names of all the instructors from Biology department. 2)Find
Please solve each question with - tuple query, relational query and domain query
1. Find the names of all the instructors from Biology department.
2)Find the names of courses in Computer Science department which have 3 credits.
3)For the student with ID 12345 (or any other value), show all course_id and title of all courses registered for by the student.
4)For the student with ID 12345 (or any other value), show the total number of credits taken by that student. Use SQL aggregation on courses taken by the student .
5)Display the total credits for each student, along with the ID of the student; don't worry about the name of the student. (Don't bother about students who have not registered for any course, they can be omitted).
6)Find the names of all students who have taken any Comp. Sci. course ever (there should be no duplicate names) .
7)Display the IDs of all instructors who have never taught a couse. (Note: Oracle uses the keyword minus in place of except).
8)Find the maximum and minimum enrollment across all sections, considering only sections that had some enrollment. (Don't worry about those that had no students taking that section.) . 9)Find all sections that had the maximum enrollment (along with the enrollment), using a subquery.
10)Find all courses whose identifier starts with the string "CS-1".
11)Create a view faculty showing only the ID, name, and department of instructors.
12)Create a view CSinstructors, showing all information about instructors from the Comp. Sci. department .
13)Find all rooms that have been assigned to more than one section at the same time. Display the rooms along with the assigned sections. (Hint: use WITH or views.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started