Normalisation

Assignment One: Normalising data



Normalisation is a bottom-up approach to database design that begins by examining the relationships between the attributes that in turn make up the database.

For this example of normalising data we are going to use data from AllRight Accounting which is a firm that stores data about their customers various policies with other companies.

The forms that we are extracting the data from are standard forms used by AlRight Accounting to receive the necessary information on their customers. Here the user fills in a form with details such as Personnel Details, Policy Details, and Company Details.


Aaron’s Accounting
Client Number: CN 34 Policy Number: PN 12
Full Name: Karen Hatfield Policy Description: Covers holder for full Dental treatment
Monthly Debt: £50 Company Number: CN 100
Policy Start: 1- Sep - 99 Company Name: Dave’s Dental
Policy Expire: 1- Sep - 00


Source of data:...