Database Analysis : A Database

989 Words4 Pages
A database is defined as an organized collection of data, typically in electronic form. A properly designed database provides access to accurate well organized information. This is essential to achieve the goals that where outlined when the database was first planned. Certain principles are required when designing a good database. One principle that is very important is the elimination of duplicate data, also known as redundant data, which not only waste space but adds confusion. According to the official Microsoft Office support site,” A good database is one that: Divides your information into subject-based tables to reduce redundant data, provides Access with information it requires to join the information in the tables together as needed, helps support and ensure the accuracy and integrity of your information, and accommodates your data processing and reporting needs.” When designing a database there are guidelines that need to be followed. These guidelines are an essential part of making sure the database is well constructed and serves the intended purpose. First is to determine the purpose of the database. It is a smart idea to write down what the database is going to be used for. This will help with keeping on track on not getting away from the intended purpose of the database. Second is finding and organizing the required information. Using existing list such as ledgers or a list of customers will assist with getting the database started. Next determine how this
Get Access