cs186_fa07_mt1_sol 5

cs186_fa07_mt1_sol 5 - d[5 points Given the following...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: d)[5 points] Given the following Relational Calculus statement: {B | BBooks(A1Authors(A1.birthYear>1920) (A2Authors(A2.birthYear>1920 A2.birthYear>A1.birthYear B.author=A2.name))} circle the Relational Algebra expressions that compute the same result. i) (A1, birthYear > 1920 Author) (A2(name2, c, birthYear, bp), birthYear > 1920 Author) isbn, title ,author (Books author=name2 (A2.birthYear > A1.birthYear(A1 A2))) ii) Books ( (Books birthYear < 1921 Author) (Books birthYear < 1920 Author) ) iii) All the above iv) None of the above Your answer: i i: 5/5 ...
View Full Document

This note was uploaded on 08/30/2009 for the course CS 186 taught by Professor Staff during the Fall '08 term at Berkeley.

Ask a homework question - tutors are online