Register

3NF

18,748 views
1 votes
1 votes

 Consider a relation R with five attributes ABCDE. You are given the
 following dependencies: A → B, BC → E, and ED → A.
1. List all keys for R.
2. Is R in 3NF?
3. Is R in BCNF?

User Avatar

2 Answers

1 votes
1 votes
1.all the keys of R are:(3 keys)

ACD+ ={ACDBE}

BCD+ ={BCDEA}

ECD+={ECDAB}

2. since in all the FD's , R.H.S is prime attribute hence R is in 3NF

3.R is not in BCNF, because L.H.S is not a key in the given FD's
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
PRIYANKA pp PIU asked Mar 16
99 views
Explain why BCNF is said to be improved 3NF.
User Avatar
0 votes
0 votes
2 answers
2
Souvik33 asked Jan 14, 2023
530 views
Made Easy Test Series | 3NF | True/False
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of R TRUE FALSE
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of RTRUEFALSE
User Avatar
2 votes
2 votes
0 answers
3
h4kr asked Dec 15, 2022
356 views
Since it is already in 3NF, why decompose further?
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
User Avatar
0 votes
0 votes
0 answers
4
Varun Raj Akula asked Mar 12, 2022
387 views
Transitive Dependency and Intransitive Dependency in 3NF.
Can anyone please explain about Statement 4 ? I know that transitive dependencies are allowed in 3NF as long as RHS is Prime Attribute. But, what is intransitive dependency. What is the role of it in 3NF?
Can anyone please explain about Statement 4 ? I know that transitive dependencies are allowed in 3NF as long as RHS is Prime Attribute. But, what is intransitive dependen...
User Avatar
Link Copied!