This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: does it differ from a simple table of data? 7. What are the different types of integrity constraints? Give examples. 8. Consider the COMPANY schema shown in Figure 5.5 in the text book. Give relational algebra expressions for the following queries: (a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project. (b) List the names of employees who have a dependent with the same first name as themselves. (c) Find the names of employees that are directly supervised by 'Franklin Wong'. 9....
View Full Document
This note was uploaded on 02/23/2012 for the course CS 348 taught by Professor Staff during the Fall '08 term at Purdue.
- Fall '08
- Computer Science