4400_quiz2_fall2010_WITHKEY[1]

# 4400_quiz2_fall2010_WITHKEY[1] - CS 4400 QUIZ 2 Fall 2010...

This preview shows pages 1–4. Sign up to view the full content.

CS 4400 QUIZ 2 Fall 2010 SECTION:________ NAME:________________________________________________________ GT ID:_______________ (1) a b c d (2) a b c d (3) a b c d (4) a b c d (5) a b c d (6) a b c d (7) a b c d (8) a b c d (9) a b c d (10) a b c d (11) a b c d (12) a b c d (13) a b c d (14) a b c d (15) a b c d (16) a b c d (17) a b c d (18) a b c d (19) a b c d (20) a b c d (21) a b c d (22) a b c d (23) a b c d (24) a b c d (25) a b c d

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

View Full Document
SECTION:________ NAME:________________________________________________________ GT ID:_______________ Example Database The Email attribute is the primary key for the User, RegularUser, and AdminUser relations. The Email attribute in the RegularUser and AdminUser relations are foreign keys on the Email attribute in the User relation. The Email attribute in the Jobs relation is a foreign key on the Email attribute of the RegularUser attribute. Name is the primary key of the Employer relation. The combination of the Email, Name, and JobTitle attributes is the key of the Jobs relation. The Name attribute of the Jobs relation is a foreign key on the Name attribute of the Employer relation. Notice and don’t forget that the Name attributes of the Employer and Jobs relations both contain names of employers, whereas the Name attribute of the User relation contains names of Users.
SECTION:________ NAME:________________________________________________________ GT ID:_______________ Question 1. Which of the following is true? a) A relation, R, of degree, n, is a subset of the Cartesian product of a list of domains, D 1 ×D 2 ×… ×D n , where a particular domain, D i , may appear multiple times. b)

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

4400_quiz2_fall2010_WITHKEY[1] - CS 4400 QUIZ 2 Fall 2010...

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

View Full Document
Ask a homework question - tutors are online