Latest RDBMS Aptitude Question SOLUTION: A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

• Placement Papers
• /
• RDBMS
• /
• Logical Reasoning
• /
• Cryptography

RDBMS Question Papers:

(#M40029884) RDBMS Logical Reasoning question RDBMS Keep an EYE

A B C is a set of attributes. The functional dependency is as follows
AB -> B
AC -> C
C -> B
a) is in 1NF
b) is in 2NF
c) is in 3NF
d) is in BCNF

Asked In RDBMS MAN (10 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (4)   (2) Submit Your Solution Cryptography

Read Solution (3) :

SAHIDUL HASAN  (10 years ago)

is in 1NF
HERE AC IS CANDIDATE KEY BUT BUT NON PRIME ATTRIBUTE B IS NOT FULLY FUNCTIONALLY DEPENDENT ON AC IT DEPENDS ON PARTIAL ATTRIBUTE C OF CANDIDATE KEY AC.

Is this solution Helpfull? Yes (4) | No   

Vemula Geethanusha  (9 years ago)

a)is in 1NF
is in 1NF since (AC)+ = { A, B, C} hence AC is the primary key. Since C B is a FD given, where neither C is a Key nor B is a prime attribute, this it is not in 3NF. Further B is not functionally dependent on key AC thus it is not in 2NF. Thus the given FDs is in 1NF.

Is this solution Helpfull? Yes (1) | No   

nitish kumar yadav  (10 years ago)

this functional dependency is in 3 NF as there is no transitive or partial dependency,
the candidate keys here are AB and AC.

Is this solution Helpfull? Yes | No (1)  

Please Login to Read Solution.