I've been reading many different sources on how to differentiate relations that are in 3NF/BCNF. And I've so far this is my understanding... I will use this relation as an example... R = {A, B, ...

I have the following functional dependencies (they represent all the functional dependencies on my relation): (1) BrokerName -> Office (2) StockName -> Dividend (3) InvestorId -> BrokerNa...

What is a KISS (Keep it Simple, Stupid) way to remember what Boyce-Codd normal form is and how to take a unnormalized table and BCNF it? Wikipedia's info: not terribly helpful for me.

Can someone please explain the difference between 3NF and BCNF to me? It would be great if you could also provide some examples. Thanks.