Unformatted text preview: cause problems with adding new data, changing data, and deleting data from the database. When normalization rules are used, potential problems can be seen quickly and can be resolved before any actual data are entered into the database. The topic reading gives a very good example of why normalization is important. It gives an example that a business can use a mailing code instead of typing in the city name repeatedly. This reduces error and also saves time when entering new data. This would be especially important and useful for payroll. For example, if a company has all of its paychecks being sent from one location to all of their employees all round the country, it would be much easier to have mailing codes as opposed to entering city names for the sake of making sure there are no mistakes. In this instance, a mistake would be sending an employee's paycheck, or even paystub, to the wrong person....
View Full Document
This note was uploaded on 07/13/2011 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Penn State.
- Summer '08