Designing the database
The more time you spend planning and organizing your data structure the better served you will be in the long run. The key to designing an efficient database is to understand how any relational database system stores information and how it can be viewed.
Here are the important points
Point A:- Relational databases such as those written in Microsoft Access do not store data in a logical way that you would perceive.Microsoft Access requires a whole host of facts about subjects that are to be stored, the relationships between each subject and the indexes that separate them, but keep them connected.
Point B:- These said subjects and the relationships they share must maintain relevant data items, without duplication or redundancy and with considerable thought to validation. If data is duplicated or wasted blank space then it reduces the capacity of the database to provide you with the service you desire. Be it speed, resilience or aesthetics.
In the next part in this series we will discuss a phased approach to database design, looking at brainstorming workflows, drawing up realistic database goals and determining fields, tables and their relationships. Following this, it will then be possible to begin designing your prototype system, automating / validating data inputs and output mechanisms and finally building a test harness that is both pertinent and relevant to your bespoke requirements.