Register

BCNF Normal form

1,314 views
1 1 vote
R(A,B,C,D,E)

AB ---> E

CD ---->A

B ------>C

Decompose the following relation to BCNF and also state whether it is lossless and dependency preserving

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Synchronization mech...Next → · #self doubt
← Previous in category · Number of tablesNext in category → · ER DIAGRAM
Position:
Show:

Related questions

10 10 votes
1 answers 1 answer
6.5k
6.5k views
Na462 asked May 29, 2018
6,459 views
3NF But Not in BCNF Normal Form
Which of the following statement false of relation $R$ is in $3NF$ but not $BCNF$?Relation $R$ must consist atleast two over-lapped candidate keys.Relation $R$ must consi...
14 14 votes
6 answers 6 answers
21.3k
21.3k views
Shefali asked Sep 17, 2015
21,343 views
3NF But Not in BCNF Normal Form
Consider the following statements.If relation R is in 3NF and every key is simple, then R is in BCNFIf relation R is in 3NF and R has only one key, then R is in BCNFBoth ...
3 3 votes
2 answers 2 answers
1.2k
1.2k views
gauravalgo asked Jun 15, 2015
1,218 views
is the following relation is in BCNF form
r={a,b,c,d,e}a->bbc- eed - a
0 0 votes
3 answers 3 answers
1.6k
1.6k views
Souvik33 asked Dec 17, 2022
1,609 views
Database Relations | Heighest normal form
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc)Then consider the following options:The relation is surely in BCNFT...