The student exercise for this lab is similar to the sample exercise presented above .
Consider the following spreadsheet containing information about customers , their shipping and billing addresses , and the countries 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 _ ad dr 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