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

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

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

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

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

Page1 / 2

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

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