More permanent stuff at http://www.dusbabek.org/~garyd

12 June 2006

Database Design 101

This is a gripe.

I've been working on a project lately that was designed and implemented by what I can only describe as a novice. One table I am working on has the table name prefixed to every column name. So if the table was "Person", we have have:

create table Person (
PersonName varchar(255),
PersonSSN varchar(9),
PersionDOB date)

instead of something else:
create table Person (
Name varchar(255),
SSN varchar(9),
DOB date)

There are about ten columns in this table too. Ouch!

0 comments: