Student Exercise

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.

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.

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.

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.

Draw the ERD for exercise 3, using Crows Foot notation. Paste your solution into the answer sheet, and label it, Answer #4.

20 Joh 20 Joh 20 Joh 17 Hild Yeage 217 217 387 17 Hild Yeage 217 217 392 109 203 109 3280 United 6 123 Happy Ave 9 2024 Shorline Dr. Seattle A 3 100 N. Kent Ave Smith Orlando FL 1 76States 109 203 203 W 9810 United Smith 1 76States 109 203 805 Smith St. James A 34 Jamaica Dusseldo 948 Spatzel Ct 5111 29 German 7500 1 162 Rue Moritz Paris 128 France 32 188 188 188 Cupertin 9501 United 1 Siri Apple 1 1 Infinite Loo CA 4 76States 20 Joh 20 Joh 20 Joh 17 Hild Yeage 217 217 387 17 Hild Yeage 217 217 392 109 203 109 3280 United 6 123 Happy Ave 9 2024 Shorline Dr. Seattle A 3 100 N. Kent Ave Smith Orlando FL 1 76States 109 203 203 W 9810 United Smith 1 76States 109 203 805 Smith St. James A 34 Jamaica Dusseldo 948 Spatzel Ct 5111 29 German 7500 1 162 Rue Moritz Paris 128 France 32 188 188 188 Cupertin 9501 United 1 Siri Apple 1 1 Infinite Loo CA 4 76States