1. Normalization is a database design technique which organizes tables in a manner that reduces _______________________ of data
2. Another definition of normalisation is as follows. Fill in the blanks
3. Typically, normalisation divides ________________________________________
4. The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First ____________, and he continued to extend theory with Second and Third ________________
5. Which of the following are valid reasons for normalising a database?
6. Can you identify any problems in the following database table design?
7. Which of the following are also problems/anamolies that can occur due to the lack of normalisation? (refer to above image)
8. The "normalisation oath" is used as a little tip to help remember the concept: "Each attribute is dependent on the key, the whole key, and _______________________"
9. The process of refining the structure of a database to ______________________________________ is called normalisation. When a database has been normalised, it is said to be in normal form
10. A database is in _______if there are no repeated fields. That means that there must only be one field for each item of data you want to score.
11. A database is said to be in second normal form if it: is already in first normal form ________________________________
12. If you had a table with the following fields, assume 'Name' was the key: It isn't in 2NF beacuse:
13. A database is in 3NF if: it is in 2NF and ______________________________________________
14. This table has a composite primary key [Customer ID, Store ID]. The non-key attribute is __________________
15. In the above example, [Purchase Location] only depends on [Store ID], which is only part of the primary key. Therefore, this table does perfectly satisfy second normal form.
16. In this example there are no partial functional dependencies. This means that the column [Purchase Location] is fully dependent on the primary key of that table, which is [Store ID]
17. The following database appears to be in 3NF
18. The following is not in 1NF because _______________________________________
19. In the example below, state why the database is not normalised.
20. For the question and example above, how could the database be put into Third Normal Form?