Consider the salesData.csv spreadsheet provided. This spreadsheet contains data about product sales made at a given company. It is a single spreadsheet $($table$),$ but it contains information on users, products, stores and other info. The functional dependencies are a mess in this table! We say it is denormalized, or simply not normalized.

Decompose the sales data table until you are left with only tables in Boyce$-$Codd Normal Form. To do this, write CREATE TABLE SQL queries that could be used to create new normalized tables by selecting data out of the denormalized data provided. Here's information about the data that will help you determine what tables we get.

Assume our CSV has been loaded as a table called "SALESDATA$\_$RAW"

Every field that has $"$ID$"$ in its name can be used to uniquely identify something

Not every unique identifier necessarily has ID in its name

Usernames are unique to a given user

Store names are not unique, but each store has only one name

Product names are not unique, but each product has only one name

The country information pertains to what country the user's account is set up in

Each user's account is set up in exactly one country

The price and currency are determined by which product you are buying

A time of sale is recorded for each sale

Once you have decomposed the table, we need to enforce integrity on our resulting normalized tables. Write DDL statements to create any primary or foreign keys your tables will need.

Note: You can load this spreadsheet into Access and do your work in there to derive and test your solutions. You can also attempt to just directly write the code. Make sure you just submit your code. Do not submit your $.$accdb file.