Indicate whether the following statements are true or false on the student answer sheet.
1 T | Normalization is the process of removing anomalies from database design. 2 T | Not being able to insert data because other data is required is an example of an insertion anomaly. 3 F | An insertion anomaly occurs when you enter data inaccurately. 4 T | An update anomaly occurs when you have to update the same data in multiple places. 5 F | 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. 6 T | Normal forms are sets of rules designed to remove anomalies and redundancy from database design. 7 T | The First Normal Form removes all repeating groups and arrays. 8 T | Rather than put several values in a single column, you should create several columns and number them like column1, column2, etc. 9 T | Second Normal Form removes functional dependencies.
10 T | Functional dependencies consist of groups of related attributes that form subsets within an entity. 11 T | Failure to normalize a database can lead to numerous problems. 12 T | Third Normal Form removes transient dependencies.
13 T | A transient dependency is where an attribute depends on another attribute for its meaning and not on the key. 14 F | If you know you are going to denormalize your database, you don't need to normalize it in the first place. 15 T | Denormalization should never be done lightly.
16 F | You should limit repetition of attributes to the repetition of the primary key as a foreign key in a related table. 17 T | Each individual attribute should represent only one type of value. 18 F | There are only three normal forms.
19 T | One way to think of functional dependencies is as separate themes in the same table or entity. 20 F | Normalization is about designing databases so they work well on the computer, not about readability.