IT 203_Week04_Homework

IT 203_Week04_Homework - IT 203 Trinity Martin Week 04...

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

View Full Document Right Arrow Icon
IT 203 Trinity Martin Week 04 Homework A. Which normal form specifies that a non-key field may not determine another non-key field? a. 1NF b. 2NF c. 3NF d. 4NF B. A table has a composite key. A non-key field is determined by only part of the primary key. Which normal form does this violate? a. 1NF b. 2NF c. 3NF d. 4NF
Background image of page 1

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

View Full DocumentRight Arrow Icon
C. The Student table includes the fields StudentID, FirstName, LastName, and ClassesAttended. Which field violates 1NF? a. StudentID b. FirstName c. LastName d. ClassesAttended D. Which is an identifying characteristic of denormalized data? a. Unrelated tables b. Duplicate data c. Composite primary keys d. Large numbers of data rows E. How do you resolve a 1NF violation in a table? a. Create one or more additional tables. b. Ignore the violating attributes. c. Add one or more columns to the primary key. d. Add one or more additional primary keys. F. The Student table includes the following keys: • StudentID (primary key) • LastName • FirstName • e_mail • Advisor
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/26/2011 for the course IT 203 taught by Professor Accampo,e during the Spring '11 term at ITT Tech Pittsburgh.

Page1 / 3

IT 203_Week04_Homework - IT 203 Trinity Martin Week 04...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online