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

Ask a homework question - tutors are online