1 / 9

Database Query Problems: Relational Algebra Examples & Solutions

Explore relational algebra examples to solve query problems efficiently. Learn how to divide databases and interpret results with practical T1/T2 examples. Find solutions to various query challenges, including faculty search, course prerequisites, class capacities, and student grades.

achilles-tocci
Télécharger la présentation

Database Query Problems: Relational Algebra Examples & Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Relational Algebra • Divide Examples • Query Problems

  2. Divide Example T1 T2

  3. What is the result of the following divide expression? T1 / T2

  4. Divide Example CoursesCompleted DatabaseCourseCodes

  5. Divide Example • What is the result of the following query? • CoursesCompleted / DatabaseCourses • What question could the above expression be an answer to?

  6. Query Problems • Find the faculty (all attributes) in the computer science department (DeptID CS) • Find the names of faculty in the computer science department • Find the capacity of classrooms with more than 100 seats • Find the names of courses that have a prerequisite of CS 220

  7. Query Problems • Find the names of courses offered in the Spring • Find the names of students who received an Incomplete in Fall 2012. • Find the names of courses that have never been taught. • Find the names of faculty who taught a class in Spring of 2012 • Find the names of students who have passed all prerequisites for CS 442

  8. Query Problems • Find the names of students who have passed all computer science courses. • Find the names of faculty who taught a courses that is a prerequisite for MTH 444 in Fall 2012. • Find the names of faculty who taught all courses that are prerequisites for MTH 444 in Fall 2012.

  9. Query Problems • Find the class(es) with the smallest enrollment in Spring of 2013. • Find the name(s) of the course(s) worth the most credits

More Related