2.1k views

Consider the following table

The table is in which normal form?

1. First Normal Form
2. Second Normal Form
3. Third Normal Form but not BCNF
4. Third Normal Form and BCNF
| 2.1k views

Third Normal Form but not BCNF

See the dependencies

AB ---> CDE

C ---> B

C is not a Super key Here

by Boss (45.3k points)
0
can B be considered as a prime attibute?
0
yes B is prime attribute along with A and C
0
Sorry but C is not a prime attribute. Prime attributes are those which are part of candidate key.
+1
@Gaurav , here AB and AC are candidate keys .. So A,B and C are prime attributes..
AB is the key here which determines C ,D E there is no P.D  and T.D between C,D,E SO IT IS IN 3NF

Now for BCNF every determinant is a candidate key determinant here are A,B,C (as C determines B) but C is not  candidate key hence it is not in BCNF (only if C->B is removed it becomes BCNF)

AC is also key  which can determine B and so also  D , E  but B is not candidate key

hence ans is C
by Boss (48.8k points)
edited
+1
AC is also a key

Dependency:

AB ---> CDE

C ---> B

1NF(yes): assume all attributes are atomic

2NF(yes): no partial functional  dependency like A alone can derive C or D or E

3NF(yes): no transitive functional dependency or there is nothing like (non key)-->(non key)

BCNF(no): in non trivial FD C-->B  , C is not a SuperKey.

by (73 points)

It is 3NF

Bcz AB->CDE ,here we can clealy see that AB is super keys that's why it will be in 3NF and BCNF but C->B it is in 3NF not in BCNF that's why we can say that it will be in 3NF not in BCNF bcz both of them should be in BCNF not single one.

by Boss (10k points)