The Gateway to Computer Science Excellence
+5 votes

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
in Databases by Veteran (105k points) | 2.1k views

4 Answers

+9 votes

Answer : C

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)
can B be considered as a prime attibute?
yes B is prime attribute along with A and C
Sorry but C is not a prime attribute. Prime attributes are those which are part of candidate key.
@Gaurav , here AB and AC are candidate keys .. So A,B and C are prime attributes..
+5 votes
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 by
AC is also a key
+4 votes

Answer : C


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)
+2 votes

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)

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,458 answers
100,251 users