Please pay attention to each table is start with CustomerID and end with prodectline

"Your Business" is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to 2 NF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF ). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields. "Your Business" is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to 2 NF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF ). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields