Which normal form is this violating?

I'm having the usual disputes about database design issues.

The information that my coworkers have is say, x and y. It has a one to one relationship. Therefore, it goes into one and the same table.

Table_A
Fieldx (pk)
Fieldy

However, they are arguing that it goes into another table.

Table_A
Fieldx (pk)

Table_B
Fieldx (pk)
Fieldy (not null)

(Actually, thye have "designed" a number of strange tables, and then put views on top of them, to come back to the same one to one relationship. Very strange and complex. )

What normal form does this violate? It isn't 1st, 2nd, or 3rd. Boyce-Codd maybe? The crazy thing about the design texts, is that they rarely cover mistakes in design. This is a common one.

Thanks Received on Thu Apr 25 2002 - 06:31:04 CEST