Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am designing a web application for a post office. Performance in database is critical for them. I have designed the below structure for the post database, is there any flaw in my db structure which I didn't pay attention to ? I couldn't post the image please someone do that for me.

share|improve this question
up vote 1 down vote accepted

First, that's not a database structure. Post column names, keys, constraints, and so on.

Second, performance is not critical. Data integrity is critical. Returning the wrong answer really, really fast won't help any post office.

Third, data integrity depends on keys, constraints, and so on. See "First".

share|improve this answer
I worked with a great DB2 DBA many years ago who described his job as "helping people make bigger and better mistakes, faster." - I agree that this is not a question in its current form. – Joel Brown Dec 4 '11 at 16:41
I'll post that a few days later, tnx. – Alireza Hos Dec 5 '11 at 11:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.