CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 47

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
FOR MORE CLASSES VISIT