Database-Management-System
August 29, 2024Transactions
August 29, 2024Database-Management-System
|
Question 842
|
For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold :
-
a → c
b → d
The relation is in
|
First normal form but not in second normal form
|
|
|
Second normal form but not in third normal form
|
|
|
Third normal form
|
|
|
BCNF
|
Question 842 Explanation:
Primary key of given relation is “ab”.
And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.
And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.
Correct Answer: A
Question 842 Explanation:
Primary key of given relation is “ab”.
And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.
And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.