Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 502
|
A function that has no partial functional dependencies is in __________ form.
|
3 NF
|
|
|
2 NF
|
|
|
4 NF
|
|
|
BCNF
|
Question 502 Explanation:
To qualify for second normal form a relation must:
(1) be in first normal form (1NF)
(2) not have any non-prime attribute that is dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.
(1) be in first normal form (1NF)
(2) not have any non-prime attribute that is dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.
Correct Answer: B
Question 502 Explanation:
To qualify for second normal form a relation must:
(1) be in first normal form (1NF)
(2) not have any non-prime attribute that is dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.
(1) be in first normal form (1NF)
(2) not have any non-prime attribute that is dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.