Huge ruckus broke out in one of my project groups yesterday. It was over the definition of Boyce-Codd normal form.
I know the definition is every every determinate is a candidate key. We were going round and round about what constitutes a determinate.
I said if the table looked like this masterList(masterID, fName, LName, userName, password) we would be ok. Another guy said we need to break up the table because userName and masterID uniquely identify the tuple. I said that it only uniqly identifies the tuple if we say so. This went on for about half an hour with many valid points on both sides and wound up a jump ball. Anybody care to settle this bar fight?

A.

Reply via email to