reset password
Author Message
LarukuRock
Posts: 10
Posted 18:46 Oct 13, 2015 |

Professor Sun, I just wanted to clarify, the directions for Homework 2 said: list the functional dependencies and determine whether the table is in BCNF or 3NF. Is it sufficient for example if we just say a table is not in BCNF because it violates one of the principles of a BCNF? Or, do we have to completely convert a badly designed table into a BCNF one? Thanks in advance!

 

cysun
Posts: 2935
Posted 19:00 Oct 13, 2015 |

Determining if the tables are BCNF is enough. You don't need to decompose non-BCNF tables to BCNF.

LarukuRock
Posts: 10
Posted 19:12 Oct 13, 2015 |

Thank you professor.