Back to category: Technology Limited version - please login or register to view the entire paper. 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:... Posted by: Tamara Moore Limited version - please login or register to view the entire paper. |
|
© 2006 TermPaperAccess.com |