Week6 - Multi-valued Dependencies and Fourth Normal Form / Explore

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Which of the normal form is based on multivalued dependencies?

(d) Fourth

2. What is the primary focus of achieving 4NF in database design?

(c) To eliminate redundancy by addressing multivalued dependencies.

3. What is Multivalued Dependency (MVD) in DBMS?

(d) A dependency where two separate attributes are independent but both depend on another third attribute.

4. Consider the following relation:

Employee_Details (Emp_ID, Emp_Name, Emp_Department, Emp_Project)

Question 1
Which of the following represents a multivalued dependency in the Employee_Details relation?

(d) Emp_ID →→ Emp_Project

Question 2
To bring the Employee_Details relation to 4NF, what would be an appropriate decomposition strategy?

(a) Decompose the relation into two tables: Employee (Emp_ID, Emp_Name, Emp_Department) and Project (Emp_ID, Emp_Project).

5. Match List I with List II:

A. BCNF i. It removes multivalued dependency
B. 3 NF ii. It is not always dependency preserving
C. 2 NF iii. It removes transitive dependency
D. 4 NF iv. It removes partial dependency

(c) (A) - (ii), (B) - (iii), (C) - (iv), (D) - (i)

6. What does 4NF (Fourth Normal Form) signify in database normalization?

(b) It is a normal form that addresses multivalued dependencies in a relation.

7. How is a multivalued dependency expressed?

(b) x →→ y

8. The normal form which satisfies multivalued dependencies and which is in BCNF is

(a) 4 NF