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 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