Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The provided spreadsheet NormalizeThis.xlsx has a listing of invoices from an organization. You could think of this as the kind of invoice a small, non-computerized
The provided spreadsheet "NormalizeThis.xlsx" has a listing of invoices from an organization. You could think of this as the kind of invoice a small, non-computerized shop might have as it begins to try to record its sales electronically. D H L M N 0 Name Phone Email Invoice Date Total Amount Description 1 Price 1 Qty 1 Description 2 Price 2 Qty 2 Description 3 Price 3 Qty 3 2 John Jones 123-4567 waffle@is 12001 2/14/19 45.98 6" Apple Cab! 22.99 2 3 Wel Shen 123-4567 Wireleel 12002 2/14/19 94.94 Hello Kitty M 10.99 5 Starwars DVD 39.99 1 4 Luis Alahandro 765-4321 Zoop@Zig 12004 2/15/19 68.976"Apple Cab! 22.99 3 5 Johnny Jones 123-4567 12005 2/15/19 65.97 Wareless Mo 19.99 16" Apple Cable 22.99 2 6 John Jones 123-4567 waffle@is 12006 2/15/19 39.99 Starwars DVC 39.99 1 7 Luis Alehandro 765-4321 Zoop@zig 12007 2/15/19 220.97 Wareless Mo 19.99 1 27" Monitor 189.99 1 Hello Kitty Mu 10.99 1 a. 1) Spend some time attempting to normalize this data set (spend at least an hour-if you are fast you might think you are "all done" before that - ok.) Create several tables in MS Access for different entities/ tables in your normalized design b. Type in the data in the Excel table into your MS Access tables. C. Clean up data problems as you go along. For example, remove duplicated data entries. d. Here are some specifics to get you started i. Create a table for customers,"clean up" the customer list so that it has only three people. Assign each person a unique ID such as we might use as a primary key in a database (I suggest 4 attributes/columns: cust_id, cust_name, cust_phone, cust email you should have three rows) ii. Create a table for products, assign a unique product ID for each listed product (1 suggest 3 attributes, prod. ID prod Desc, prod price) one good answers has 5 rows for 5 products, maybe 6 if you count the new Lightsaber product iii. iv. Create a table for the invoices V. You may need one or more bridge tables that can solve the M:N relationship. 2) Make a substantial post (three paragraphs or so, or perhaps the equivalent of that in bullet points) describing things you did. Include your MS Access file in the post
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started