4400_quiz2_fall2010_WITHKEY[1]

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
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)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online