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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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".