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.
You might also like to view...
Each local storage device on a Windows-based computer is identified by a unique device letter, which for the hard disk is usually _____.
A. A B. C C. B D. D
Individual permissions can be set using the ____ program without any programming.
A. policytool B. securityManager C. gc D. policy
Oracle, Microsoft Access, and MySQL are all examples of a(n) ____.
A. DBMS B. SQL statement C. 3NF D. word processor
In a token ring network, the busy token is removed from the ring and replaced with a free token
a. by the receiver of the data b. by any standby monitor c. by the active monitor d. by the sender of the data