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.