Test 2 Practice

# Test 2 Practice - TEST 2 PRACTICE EXERCISE This is provided...

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

TEST 2 PRACTICE EXERCISE: This is provided as practice for Test 2 normalization problems. Data Structure: You may assume that the primary key (underlined) is correct, and repeating groups are shown in italics . EXAMPLE: ACTOR(A-Name , DOB, Gender, Nationality, Movie-Title, Length, Yr-Made ) 1. Is the example in third normal form (3NF)? A. No, because it has repeating groups B. No, because one or more non-key attributes depend on a part of the key and not the entire key C. No, because one or more non-key attributes depend on another attribute other than the key D. Yes, it is in third normal form (3NF) 2. What is the highest normal form of the example? A. Not in First Normal form (1NF) B. First normal form (1NF) but not Second Normal form C. Second normal form (2NF) but not Third Normal form D. Third normal form (3NF) E. None of the above 3. In the example above, A-Name is defined as the primary key. Describe a better solution for a primary key. (What is the problem with Name as a primary key?)

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 / 2

Test 2 Practice - TEST 2 PRACTICE EXERCISE This is provided...

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

View Full Document
Ask a homework question - tutors are online