Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

previousPrevious article   Next articlenext back to categoryAccess articles

article MS Access and Database Normalisation

Microsoft Access is at the forefront of database creation, maintenance and flexibility. It is fluent with all Microsoft Office applications and allows you to track and report information with ease, though Access training is certainly advisable so as to ensure that you acquire optimal functionality from the application.

Whether you are new to databases or have been creating and working with them for some time, you are bound to have heard the term 'normalisation'. If not, a very brief description of normalisation is: the process of efficiently organising data in a database.

The two predominant purposes of the normalisation process are to eliminate redundant data (i.e. to remove replicated data) and to ensure that data dependencies make sense (i.e. only related data is stored in a table) and, in so doing, to safeguard the database against certain types of logical or structural problems.

Both of these purposes are valid as they reduce the amount of storage space required to maintain the database and ensure that the data is logically stored. When multiple instances of a given piece of information occur in a table, the possibility that these instances will not be kept consistent when the data within the table is updated is avoided, therefore avoiding a loss of data integrity.

Normalisation is often considered to be a luxury that only academics and more experienced database creators have time for. This is however not the case, as knowing and implementing the principles of normalisation to your database design tasks really isn't all that complicated and it can drastically improve the performance of your DBMS (Database Management System).

There are five stages of normalisation that have been developed by the database community. They are referred to as normal forms and progress from least restrictive to most restrictive - from First Normal Form (1NF) to Fifth Normal Form (5NF).

Most commonly, database designers and operators do not implement anything higher than 3NF, with the 5NF rarely being seen because higher degrees of normalisation typically require more tables which then create the need for a larger number of 'joins' which can lead to a reduction in the performance of the database.

A brief description of the first three normal forms is as follows:

1NF sets the very basic rules for an organised database:
- Remove duplicate columns from the same table
- Create separate tables for each group of related data
- Identify each row with a unique column or set of columns

2NF assists with the further removal of duplicate data:
- Meet the requirements of 1NF
- Remove subsets of data that apply to multiple rows of a table and place them in separate tables
- Create relationships between these new tables and their predecessors through the use of foreign keys (which can be used to cross-reference tables)

3NF goes a large step further, in that it:
- Meets all the requirements of 2NF
- Removes all columns that are not dependent upon the primary key (used to uniquely identify records in a database. Access can generate a primary key for your database upon request)

Author is a freelance copywriter. For more information on access+training, please visit http://www.microsofttraining.net


Original article appears here:
http://www.microsofttraining.net/article-364-ms-access-database-normalisation.html


Back to article list

Distribution notes

PUBLICATION GUIDELINES

  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.


Microsoft Office courses London
Course rating:
4.7 stars - based on 829 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom