Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bioinformatics Databases And Systems

Authors: Stanley I. Letovsky

1st Edition

1475784058, 978-1475784053

More Books

Students also viewed these Databases questions

Question

Advance warning and an explanation for the layoff.

Answered: 1 week ago