Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve each question with - turple query, relational query and time domain query 1. Find the names of all the instructors from Biology department.

Please solve each question with - turple query, relational query and time 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.

Step by Step Solution

3.51 Rating (174 Votes )

There are 3 Steps involved in it

Step: 1

1 Select from instructor department where instructor Biology department Biology 2 Select title ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Data Analysis And Decision Making

Authors: S. Christian Albright, Wayne L. Winston

6th Edition

1305947541, 978-1337225274, 1337225274, 978-0357689066, 978-1305947542

More Books

Students also viewed these Algorithms questions

Question

Differentiate between classical and operant conditioning.

Answered: 1 week ago

Question

Calculate the missing values

Answered: 1 week ago