This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 01/27/2014 for the course COP 5725 taught by Professor Staff during the Spring '08 term at University of Florida.
- Spring '08