Unformatted text preview: following questions: 1. What are multivalued attributes? [4 pts] 2. List the basic operations of the Relational Algebra with their name and their
correct symbolic notation [4pts]. 3. What are aggregate functions? Give examples of some aggregate functions in SQL. 4. What is a 1 : m relationship set R between two entity sets E1 and E2? 5. What is generalization? Exercise 2 (Relational Algebra) [30pts] Consider the following schema: Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer...
View Full Document
- Spring '08
- Algebra, Relational model, relation, Relational calculus