Tell me more ×
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. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

http://i.stack.imgur.com/bSEMP.jpg

share|improve this question

1 Answer

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. – john.locke Dec 5 '11 at 11:16

Your Answer

 
discard

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.