This preview shows pages 1–2. Sign up to view the full content.
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 03/09/2010 for the course CS 348 taught by Professor Staff during the Spring '08 term at Purdue University-West Lafayette.
- Spring '08
- Computer Science