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...
Oracle, Microsoft Access, and MySQL are all examples of a(n) ____.
A. DBMS B. SQL statement C. 3NF D. word processor
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
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
Individual permissions can be set using the ____ program without any programming.
A. policytool B. securityManager C. gc D. policy