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
- Spring '08
- Computer Science, Relational model, Purdue University, terms Primary Key, Science Department CS, Bharat Bhargava, non-procedural query language