Module 4: Understanding Normalization.

 

Understanding Normalization.

1. If Y = X + 10, which of the following is correct?

A. X is dependent and Y is determinant

B. Y is dependent and X is determinant

C.Z is transitively dependent on X

D. None

Answer: B

2.  Examine the table; BOOK (ISBN, Title, Author_id, Author_name) is a table, where ISBN is the primary key. Which one is true?

A. Author_name is full-functionally dependent on ISBN   

B. Author_name is transitively dependent on ISBN 

C. Author_name is partially dependent on ISBN

D. They have a cyclic dependency

Answer: B

3. _________ and ___________ both attempts to minimize the number of fields in composite keys

A. 3NF and 4NF

B. 4NF and 5NF

C. 2NF and 3NF

D. All

Answer: B

4. __________ eliminates cyclic dependencies.

A. 2nd normal form

B. 3rd normal form

C. 4th normal form

D. 5th normal form

Answer: D

5. In beyond 3nf (easy way) potentially null valued fields are moved into a new table, creating one-to one or zero relation ship

A. True

B. False

Answer: A

6. 5th normal form happens if?

A. Table is in 4th normal form

B. For multi valued dependencies

C. For cyclic dependencies

D. None of above

Answer: A,C

7. Boyce-codd form happens if?

A. Table is in 3th normal form

B. For multi valued dependencies

C. For cyclic dependencies

D. Table can have only one candidate key

E. None of above

Answer: A,D

8. Caused when a record is added to a detail table, with no related record existing in a master table. What is this?

A. Delete anomaly

B. Insert anomaly

C. Update anomaly

Answer: B

9. If X determines Y and Y determines Z then what types of dependency between X and Z?

A. Functional dependency

B. Cyclic Dependency

C. Transitive Dependency 

Answer: C

10. 4th normal form happens if?

A. Table is in 3th normal form

B. For multi valued dependencies

C. For cyclic dependencies

D. None of above

Answer: A,B

11. If a field is a comma delimited list or collection of same kind then what of dependency is called?

A. Cyclic dependency

B. Multiple dependency

C. Multi-valued-Dependency

D. Transitive dependency

Answer: B,C

12. When Boyce codd Normal form and third normal form are same and one?

A. When there is only one foreign key

B. When there is only one unique key

C. When there is only one candidate key

D. None of above

Answer: C