Explain how 3rd normal form can reduce insert update and


Your management has had a chance to review the ERD that you are proposing and like the progress show so far. However, they are concerned about duplicate data and how the current system can ensure that data is kept in sync. After all, previously they had 2 different applications and you have convinced them that one is best, but how can this single application prevent people from needing to still make changes to data twice. For this discussion board describe Normalization and how it can be used to solve insert, update and delete anomalies. Your post should include the following details:

•A definition and purpose of Normalization.

•Describe the requirements for 1st, 2nd and 3rd Normal Form.

•Explain how 3rd Normal Form can reduce insert, update and delete anomalies.

Solution Preview :

Prepared by a verified Expert
Data Structure & Algorithms: Explain how 3rd normal form can reduce insert update and
Reference No:- TGS01141745

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)