Register

Please solve This Q

447 views
1 1 vote
Q. Consider the relation R(A,B,C,D) with function dependencies

F = {AB->c,B->D}.

What is the highest normal form of this relation?

2 Answers

0 0 votes
This relation is in 1NF because AB is the primary key but D is a non prime attribute and D is dependent by a part of primary key which is B(Partial dependency).

B -> D
Voting & Accepting an answer helps improve the community
← Previous · Please solve this QNext → · made easy practice b...
← Previous in category · Please solve this QNext in category → · block nested query
Position:
Show:

Related questions

1 1 vote
0 0 answers
489
489 views
kallu singh asked Jan 20, 2018
489 views
please solve this Q
0 0 votes
0 0 answers
538
538 views
kallu singh asked Dec 1, 2017
538 views
Please solve This Q
https://gateoverflow.in/?qa=blob&qa_blobid=7757640758658963209
2 2 votes
1 1 answer
1.7k
1.7k views
kallu singh asked Nov 10, 2017
1,662 views
Please solve this Q
Consider the relation having tuples 200, 300 and 100 respectively. The number of tuples in relation are ______.
1 1 vote
1 1 answer
8.0k
8.0k views
kallu singh asked Nov 9, 2017
7,962 views
Please solve this Q
Question: 6 Given the following functional dependencies{X → W, X → Y, Y → Z, Z → PQ}Consider the FD set implied using above FD set.Implied FD set = {X → Z, X → WY, X → W...