Your worst database design experience:
Share it with the rest of us!

Object Relational Overkill 
Perhaps you recognize the architect who thinks everything java is fantastically wonderful, but databases are a lot of trouble.

The java architect ...

sajvargs@gmail.com 
we have developed a web based application for one of the shipping companies in india. this company get clearences from various bodies for the ship operators ...

Inventory system 
I designed a database on SQL server, this is a inventory system and POS System. I stored all Purchase order, Purchase Invoice, Purchase Return, Stock in ...

The worst database as my prespective 
I think that the worst database is which that has redundant data
which lead to increase the database size and decrease the performance

______________________________________________________________________________________
...

Software Engineer  
When I first started at a non-profit medium size organization, with around 250 employees, one of the biggest databases they used at the time, was designed ...

Oracle Developer 
I was hired as a developer on a "mature" project, still running on Forms & Reports 6.0 (not 6i) in 2006. My job consisted of fixing problems in a ...

relationships - that doesn't hurt 
A huge company, a huge and terribly expensive system. About 300 tables in db wihout any relationships. They were substituted by triggers. Nice?

Ranges of Ids 
In the company I am working for my boss refuses to believe surrogate keys shouldn't be a range of numbers for different objects.

I.e. 4000-4999 for ...

Using a Sequence instead of a year number 
Using a Sequence instead of a year number: I just have to tell you this one:

While working as a DB QA manager in a large DB project, upon revision of ...

Trainee 
composite primary key

hdr table PK - > hdr ID
item table PK - > item ID

Line table PK -> hdr ID , item ID

This will create several issues. In ...

Transport Management System(Bus Pass Facility)  Not rated yet
I have designed master tables without primary key. I checked for the uniqueness of the value for the master tables in business logic before inserting the ...

Look in the OLD fields  Not rated yet
We have a vendor who's wonderful software is written in COBOL with a semi-relational structure (the relationships are not enforced and cannot be relied ...

My Fault  Not rated yet
When designing my first several databases, I asked the client if any field, item or bit of information about the data in the table was ever going to be ...

Hornet's Nest  Not rated yet
I worked in the IT department of a software firm in Canada for several years on a project designed using Visual Basic 6 and Oracle 7. The application'...