Problem 1
List the operations of relational algebra and the purpose of each.
Problem 2
What is union compatibility? Why do the UNION, INTERSECTION, and DIFFER. ENCE operations require that the relations on which they are applied be union compatible?
Problem 3
Discuss some types of queries for which renaming of attributes is necessary in order to specify the query unambiguously.
Problem 4
Discuss the various types of inner join operations. Why is theta join required?
Problem 5
What role does the concept of foreign key play when specifying the most common types of meaningful join operations?
Problem 7
How are the OUTER JOIN operations different from the INNER JOIN operations? How is the OUTER UNION operation different from UNION?
Problem 8
In what sense does relational calculus differ from relational algebra, and in what sense are they similar?
Problem 10
Discuss the meanings of the existential quantifier \((\exists)\) and the universal quantifier \((\forall)\)
Problem 11
Define the following terms with respect to the tuple calculus: tuple variable, range relation, atom, formula, and expression.
Problem 13
What is meant by a safe expression in relational calculus?