|
|
Posted by BillCo on 05/04/07 09:47
Thanks to everyone for their replies - very informative!
- I've dropped the whole _PK, _FK thing
- I've also dropped the table abreviation prefix, except to dis-
ambiguate common column names
Interestingly, I've found that going while through my test database
structure re-naming elements, that I've exposed flaws in my entity
relationship design - using redundant artificial Identifiers and
confusing data with meta-data being the biggest disasters!! - and come
away with a deeper understanding of the relational database model.
So thanks to all!
>Get a copy of SQL PROGRAMMING STYLE
might just do that!
Navigation:
[Reply to this message]
|