DFC20283-NORMALIZATION

Select the primary goal of database normalization.

• To minimize the number of tables in a database

• To remove redundant data and improve data integrity

• To increase data redundancy for better performance

• To create more relationships in the database

Which of the following is a requirement for a table to be in First Normal Form (1NF)?

• The table must have a composite key

• It must have a foreign key

• It must have no transitive dependencies

• All attributes must be atomic (no multivalued attributes)

A table is in Second Normal Form (2NF) if it is in 1NF and also:

• Has no partial dependencies

• Has no transitive dependencies

• Has no repeating groups

• Has a primary key

Identify the meaning of partial dependency?

• A foreign key that refers to multiple tables

• An attribute that depends on another non-key attribute

• A non-key attribute depends only on part of a composite key

• A table with no primary key

Which of the following is required for a table to be in Third Normal Form (3NF)?

• It should not contain foreign keys

• It must have only single-valued attributes

• It should not have transitive dependencies

• It should have repeating groups

Select the CORRECT example of a transitive dependency?

• Student_ID → Course_Code

• Course_Code → Instructor_Name → Instructor_Office

• Employee_ID → Employee_Name

• Product_ID → Product_Name

Boyce-Codd Normal Form (BCNF) is considered a stronger version of:

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

Which of the following situations requires a table to be further normalized into BCNF?

• There is a table with only one candidate key

• There are no transitive dependencies, but a non-prime attribute (an attribute that is not part of a candidate key) determines a key

• The table is already in 2NF

• The table contains atomic attributes

Identify the best defines a functional dependency (FD)

• A rule that defines how tables are joined in a database

• A dependency where a table is linked to another table using foreign keys

• A constraint where one attribute uniquely determines another

• A relationship between two entities in an ERD

If A → B is a functional dependency, identify true statement.

• A is functionally dependent on B

• B is a candidate key

• The value of A uniquely determines B

• B uniquely determines A