CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 41

corresponding to each of those addresses. A customer may be
associated with zero to many addresses. A customer may have 0 or 1
default billing address. A customer may have 0 or 1 default shipping
address. Each address may be associated with 0 or 1 countries,
while each country may be associated with 0 to many addresses.
cust_idfnamelnamedef_bill_addr_iddef_ship_addr_idaddr_idstreet_
addr city state zip country_codecountry_name
202 John Smith 1096 2039 1096 123 Happy Ave. Orlando FL 32801
76 United States
202 John Smith 1096 2039 2039 2024 Shorline Dr. Seattle WA
98101 76 United States
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.