...
Database-Management-System
October 14, 2023
Database-Management-System
October 14, 2023
Database-Management-System
October 14, 2023
Database-Management-System
October 14, 2023

Database-Management-System

Question 14

For a database relation R(a,b,c,d), where the domains a, b, c, d include only atomic values, only the following functional dependencies and those that can be inferred from them hold:

   a → c 
   b → d  

This relation is

A
in first normal form but not in second normal form
B
in second normal form but not in third normal form
C
in third normal form
D
None of the above
Question 14 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).
Correct Answer: A
Question 14 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).
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!