Please help. This is for CIS336 Lab 1: Normal Forms and Entity Relationship Diagrams.

In the exercise, you will analyze a de-normalized data set presented in the form of a spreadsheet. You will next construct a series of dependency diagrams, transforming the evolving data model from First Normal Form (1NF), to Second Normal Form (2NF), and finally to Third Normal Form (3NF). When the model has reached 3NF, you will construct the Entity Relationship Diagram (ERD) depicting the logical design of the database. Your ERD will use Crows Foot notation to denote the relationships between tables.

This is all the information given for the assignment.

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 or1 default billing address. A customer may have 0 or 1 default shipping address. Each address may be associated with 0 or1 countries, while each country may be associated with 0 to many addresses 20 Joh 20 Joh 20 Joh United 1 76 States United 3280 109 203 109 109 203 203 109 203 805 17 HildYeage217 217 387 17 HildYeage217 217 392 188 188 188 Smith 9 6 123 Happy Ave Orlando FL W 9810 Smith 9 2024 Shorline Dr. Seattle A 1 76 States Smith 3 100 N. Kent Ave St. James A Dusseldo 34 Jamaica 9 48 Spatzel Ct 5111 29 Germany 1 28 France 4 76 States 7500 Paris Cupertin 0 1 162 Rue Moritz 32 9501 United 1 Siri Apple 1 1 Infinite Loo CA 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 Using the answerto 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 answertoexercise 3, remove all transitive dependencies, and draw the new dependency diagrams. Foreach new or revised table, specify its normal form. Paste your solution into the answer sheet, and label it, Answer #3 Draw the ERD forexercise 3, using Crow's Foot notation. Paste your solution into the answer sheet, and label it, Answer #4 2. 3. 4