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.
Subscribe
Login
0 Comments