Pittsburgh pa 15147 122199 12435678 2134 jones 224

Pittsburgh, PA
15147
12/21/99 12435678
2134 Jones 224 4615 Forbes Ave,
Pittsburgh, PA
15147
12/25/99 21345678
1. List the primary key.
2. List all the FDs.
3. List all the update anomalies and provide an example of each.
4. What normal form is the relation in? Explain.
5. Apply normalization to it incrementally, bringing the relation to 3NF. That is, if
the relation is unnormalized, bring it to first normal form, then bring the first
normal form you've just created to second normal form, and then bring the
second normal form to third normal form.
For each transformation to the next higher normal form X,
o
Explain the steps you took to bring it to the normal form X.
o
Provide the normal form X's table structure, primary key(s), and the
FDs.
o
Explain why you think it is in the normal form X.
That is, if the relation were in an unnormalized form, you would explain the

transformation you performed to bring it to first, second, and third normal
forms. You would also provide the table structure, the primary key, and the FDs
for the first, second, and third normal forms. You would also provide explanation
for why you believe it is in first, second, and third normal forms.