UMGC IFSM 330 Candy Assignment
Your company wants to merge its old product order data into a new data mart to facilitate analysis. You have been tasked with writing an ETL (extract, transform, and load) code sequence, and executing it on three years’ worth of order data.
In this assignment, you will produce SQL code which scrubs and imports each of the three years’ worth of data, and produces an output file called stagingTable.
Along with these instructions, there is another document, ‘Additional Clarification on the Week 6 Candy Assignment’. Please read that document carefully.
You should also read the ‘Data Notes’ in part 3 of this document. It is very important that you understand the data and how the data changes over the three years, so you can create a ‘stagingTable’ the effectively combines the data that might have been captured in different ways over the years.
Let’s get started!
Part A: Upload all the files you will need to SQLlite:
1. Import the file called “2017_product_data_students.csv” to SQLiteonline.com. When you import it, give it the table name “pd2017” (no quotes) and set the column name to “First line.”
Get Plagiarism-Free and Quality Papers Without Overpaying at Homeworkmavens.com