1. How does the Rule of One Theme relate to Normalization?
Would you consider this part of,
or all of the normalization process?
The Rule of One Theme is very important to the normalization process. You have to only have one
theme in a table to consider it normalized.
2. In your own words, describe a DELETE unintended consequence problem. Provide an
example.
DELETE unintended consequences come up when you delete one of the rows or part of a row and it
causes problems. For example, if you have a table that has information about a football team and
football player but you decide to get rid of the player and as such, you delete the team information.
3. In your own words, describe an UPDATE unintended consequence problem. Provide an
example.
An UPDATE unintended consequence is when updating a row causes a problem. For
example, if you take the football team we were working with and update one of the players
salary on one of the rows, it doesn’t update in the rest of the table or database where that
salary was used
4. In your own words, describe an INSERT unintended consequence problem.
An INSERT unintended consequence problem is due to when you add a row or part of a row and it
causes some of the cells to be null.
5. Describe an example of a Rule of One Instance problem. How would you fix this problem?
An example of a Rule of One Instance problem could be where a cell has two types of information at
one time. This can happen if there are multiple options for the specific type of information. To fix
this you should create another column or row in your table depending on how you want the
information to be classified.
6. Consider A-->B In this example, what is A (determinate or functionally dependent)? What is
B (determinate or functionally dependent)?
A: Determinant
B: Functionally dependent
7. Consider A If A==>B, D, P, C and P --> C, is this normalized to 3 rd NF? If not, explain. In
addition, how would you fix it?
That is not 3rd Form Normalized. This is due to the transitive dependency. You would have to
create a new table where P is the primary key and included C in that table. Then you would
make P the foreign key in the old table and remove C from that table.
8. Consider AB If AB==>DPC and B-->P, is this normalized to 3rd NF? If not, explain. In
addition, how would you fix it?
No it is not normalized. This is due to the fact that it doesn’t actually normallize to the 2 nd
NF. This can be fixed by creating a new table and making B the primary key with P included
in the table, then we would go back to our original table and remove P from that table and
make B our foreign key
Table2(B,P)
Table1(AB,D,C)
9. Consider AB If AB-->DPC, is this normalized to 3rd NF? If not, explain. In addition, how
would you fix it?
Yes this is considered to be normalized to the 3 rd NF