Homework #6

due  Thursday, February 2nd 2006

 

This assignment may be done in pairs or individually

Hand printed names of submitter(s) ________________    ________________

 

  1. Find at least five (5) Microsoft SQL Server 2000 data types and their lengths.                                                                                    (10points)

data type

length

 

 

 

 

 

 

 

 

 

 

Hint:  look in SQL Server Books online

 

  1. What are five (5) characteristics of a relation?                          (5 points)

 

 

 

 

 

 

  1. What are the functional dependencies in the SKU_DATA table (on page 30)?

(1 point per dependency indicated)

 

 

 

 

 

 

  1. When are determinant values unique?

 

 

 

  1. What is the relationship between primary keys and candidate keys?