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.