1 / 3

Relational Algebra Problems

Relational Algebra Problems. Find the names of courses that are taught in the Fall and the Spring (as specified by the Whenoffered table) Find the names of courses that are taught in the Fall or the Spring (as specified by the Whenoffered table)

amelia-potter
Download Presentation

Relational Algebra Problems

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 Problems • Find the names of courses that are taught in the Fall and the Spring (as specified by the Whenoffered table) • Find the names of courses that are taught in the Fall or the Spring (as specified by the Whenoffered table) • Find the names of instructors who taught a computer science course in the Fall of 2001 and the Fall of 2002. • Find the names of instructors who taught a math course in the Fall of 2010 but not the Fall of 2011

  2. More Relational Algebra Problems • Find the names of students who passed at least one course from every department • Find the names of students who received an A in every course the student enrolled in • Find the largest (most seats) classroom

  3. More Relational Algebra Problems • R U S • R ⋂ S • R – S • πAR where A is an attribute of R • R x S • R ⋈ S • R / S assume all attributes of S are also attributes of R Suppose relations R and S contain Size(R) and Size(S) tuples. What are the minimum and maximum number of results in the following relational algebra expressions (assume union compatibility where needed)?

More Related