Explain the process you went through to normalize the data for the Gaming Master database

What will be an ideal response?

I began by examining the existing tables in the Gaming Master database and made note of the redundant data currently being entered and stored. I then determined what additional tables needed to be created. There needed to be a table for the various categories, customers, games, locations, and sales, in addition to the two tables that already existed.
I used Excel to combine the customer names from the tblEvents table with the names from the sales data. I used text functions to separate out the names in the sales data and removed any duplicates to create the data for the Customer table. I let Access assign a primary key for each customer and then used Excel to replace the name data with the corresponding primary key value. I followed this same procedure, passing data back and forth between Access and Excel until all data was normalized.