Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 464 |
For a database relation R(A, B, C, D) where the domains of A, B, C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are :
A → C
B → D
The relation R is in _______.
A → C
B → D
The relation R is in _______.
| First normal form but not in second normal form. | |
| Both in first normal form as well as in second normal form. | |
| Second normal form but not in third normal form. | |
| Both in second normal form as well as in third normal form. |
Question 464 Explanation:
Candidate key is ab.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
So answer is option (A).
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
So answer is option (A).
Correct Answer: A
Question 464 Explanation:
Candidate key is ab.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
So answer is option (A).
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
So answer is option (A).
Subscribe
Login
0 Comments