Planning a new database
Planning a new database can be a daunting task as there are so many things to consider, as we will see in this recipe. It’s easy to get overwhelmed, so here, we will present some planning ideas. It’s also easy to charge headlong at the task without planning, thinking that whatever you know is all you’ll ever need to consider, but planning is an important step.
Getting ready
Don’t wait to be told what to do. If you haven’t been told what the requirements are, then write down what you think they are, clearly labeling them as assumptions rather than requirements; you must not confuse the two.
Iterate until you get some agreement, and then build a prototype.
How to do it…
Write a document that covers the following actions:
- Database design – plan your database design.
- Calculate the initial database sizing.
- Transaction analysis – how will we access the database? ...
