A B C is a set of attributes. The functional dependency is as follows
AB -> B
AC -> C
C -> B?
Submitted by: Administratora) is in 1NF
b) is in 2NF
c) is in 3NF
d) is in BCNF
(a) 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.
Submitted by: Administrator
b) is in 2NF
c) is in 3NF
d) is in BCNF
(a) 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.
Submitted by: Administrator
Read Online RDBMS Job Interview Questions And Answers
Top RDBMS Questions
☺ | What is VDL (View Definition Language)? |
☺ | Difference between controlled and uncontrolled redundancy? |
☺ | What is RDBMS KERNEL? |
☺ | What is SDL (Storage Definition Language)? |
☺ | What is 5NF? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |