Question 10 [Mandatory] (5 points) El Given the dependency diagram shown in the below gure, answer question 10. Whe diagram has two branching lines....

Can some one tell me where I am getting the 2 wrong answers?

questions 1-7 are text based and the choices are show. Questions 8,9 & 10 pictures are uploaded. Asterix indicates my answer

Attempt 1

1. During the normalization process, a database designer works through a series of stages called normal forms

True **

False

2. Dependency diagrams provide a visual method of reviewing all the relationships among a table's attributes

True **

3. Partial Dependencies often cause duplication and redundancy of data

True **

4. The first step in moving a table to 1 nf is to eliminate the repeating groups

True**

5. Dependencies based on only part of a composite primary key are known as partial dependencies

True**

6. A tale in which all attributes are depended on the primary key, all key attributes are defined, and no repeating groups areincluded is said to be :

Answer: 3nf

7. A table that is in 2nf can be moved to 3nf by removing:

Answer: Transitive dependencies

Choices - Primary Keys, Repeating groups, Transitive dependencies, Foreign Keys

8. Chosen Partial

9. Chosen - Transitive

10 - Chosen - tables in 1nf