CS348-Assign2 - does it differ from a simple table of data?...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Purdue University Computer Science Department CS 348: Information Systems (Spring 2010) Prof: Bharat Bhargava Due, Feb. 9, 2010 Homework # 2 1. Explain the distinctions among the terms primary key, candidate key, and superkey. (See section 5.2.2) 2. Give an example of (a) simple and composite attributes (b) single-valued, multi-valued, and derived attribute. 3. What is the difference between a database schema and a database instance? Give an example. 4. What is the difference between a procedural and a non-procedural query language? Give an example. 5. When should duplicates be allowed in a relation? 6. What are the properties of a relation in a relation database system? How
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

CS348-Assign2 - does it differ from a simple table of data?...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online