CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 32

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