Database normalization

PT2520 UNIT 4 Clarence Gross 2/2/13 Normalization is the process of removing anomalies from database design. True Not being able to insert data because other data is required is an example of an insertion anomaly. True An insertion anomaly occurs when you enter data inaccurately. False An update anomaly occurs when you have to update the same data in multiple places. True A deletion anomaly occurs when you are unable to delete data in a primary key table because a foreign key table contains records related to that data. False Normal forms are sets of rules designed to remove anomalies and redundancy from database design. False The First Normal Forms removes all repeating groups and arrays. True