CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 42

202 John Smith 1096 2039 8053 100 N. Kent Ave. St. James WA 34
Jamaica
175 Hilda Yeager 2172 2172 3879 48 Spatzel Ct. Dusseldorf 5111 29
Germany
175 Hilda Yeager 2172 2172 3921 162 Rue Moritz Paris 75001 28
France
321 Siri Apple 1881 1881 1881 1 Infinite Loop Cupertino CA 95014 76
United States
Using the example solution as a guide, perform the following steps.
1. Using the CustomerAddressCountry spreadsheet show above, draw
the dependency diagram, and show all dependencies, full, partial, and
transitive. Paste your solution into the answer sheet, and label it,
Answer #1.
2. Using the answer to exercise 1, remove all partial dependencies and
draw the new dependency diagrams. For each new table created,
specify its normal form (1NF, 2NF, 3NF). Paste your solution into the
answer sheet, and label it, Answer #2.
3. Using the answer to exercise 3, remove all transitive dependencies,
and draw the new dependency diagrams. For each new or revised
table, specify its normal form. Paste your solution into the answer
sheet, and label it, Answer #3.
4. Draw the ERD for exercise 3, using Crow‘s Foot notation. Paste
your solution into the answer sheet, and label it, Answer #4.
===================================================

CIS 336 iLab 2 The Expanded Entity Relationship Diagram