Database Normalization Quiz

What does functional dependency describe?

• The relationship between fields in a table

• The relationship between users

• The relationship between tables

• The relationship between databases

What is a determinant in functional dependency?

• A field that provides functional dependency to another field

• A field that is always unique

• A field that is dependent on another field

• A field that is not related to any other field

What does full functional dependency indicate?

• B is dependent on multiple fields

• B is dependent on A and on a proper subset of A

• B is dependent on A but not on any proper subset of A

• B is independent of A

What is the goal of database normalization?

• To increase redundancy

• To minimize redundancy

• To create more tables

• To eliminate all data

What does the first normal form (1NF) state?

• No table contains multiple columns for the same information

• No table can have a primary key

• All tables must have multiple primary keys

• All tables must be empty

What is a composite primary key?

• A key composed of a single column

• A key that is always numeric

• A key composed of multiple columns

• A key that is not unique

What does the second normal form (2NF) require?

• All attributes must be multivalued

• No attributes can be present

• All attributes must be independent of the primary key

• All attributes must be dependent on the primary key

What is a foreign key?

• A key that cannot be used in queries

• A key that is always numeric

• A field related to two or more tables via functional dependency

• A key that is not related to any table

What does transitive functional dependency involve?

• A is dependent on C only

• A is independent of B and C

• A is dependent on B and B is dependent on C

• A is dependent on B and B is dependent on A

What is the purpose of eliminating transitive dependencies?

• To create redundancy

• To allow multiple primary keys

• To remove all data from the table

• To ensure all columns refer to the primary key