reset password
Author Message
ptran6
Posts: 25
Posted 16:11 Oct 08, 2010 |

Professor,

If a table does not have any nontrivial FDs, then is it in both BCNF and 3NF by default?

Thanks.

- Peter Tran

Last edited by ptran6 at 16:12 Oct 08, 2010.
cysun
Posts: 2935
Posted 16:13 Oct 08, 2010 |

Yes.

Tamnguyen
Posts: 2
Posted 17:08 Oct 12, 2010 |

if a table is3NF, does it mean it is also BCNF?

cysun
Posts: 2935
Posted 17:12 Oct 12, 2010 |
Tamnguyen wrote:

if a table is3NF, does it mean it is also BCNF?

See the last slide of the Normalization lecture notes.