M
Marian Edu
Guest
Agree with Tom, composed natural keys are not a violation of 3nf but I prefer a surrogate key (meaningless) as foreign key because: - easier to write joins - take less space (child tables and also indexes will have less fields) - allows for updates on fields part of natural key (does not trigger update on all child's records). Other than that I don't like any surrogate so please give us proper FK constraints in the database, yeah Thomas can opt not to use that but I'll live with that 
Ah, and integers do take less space (table and index) compared to guid so auto-increment fields will be a nice addition (very 4gl-ish imho). Sent from my HTC
Continue reading...
Ah, and integers do take less space (table and index) compared to guid so auto-increment fields will be a nice addition (very 4gl-ish imho). Sent from my HTCContinue reading...