Question: csv table Simple CSV Exercise Attached Files: A. (377.223KB) discounts.,sv (127 B) In this confidence building exercise you analyze E simple Comma Separated Values file

 csv table Simple CSV Exercise Attached Files: A. (377.223KB) discounts.,sv (127
csv table
B) In this "confidence building" exercise you analyze E simple Comma Separated

Simple CSV Exercise Attached Files: A. (377.223KB) discounts.,sv (127 B) In this "confidence building" exercise you analyze E simple Comma Separated Values file named discounts. csv and: - Read the provided instructions - Design a SOL table that will hold the data in this CSV file. (Every column in the CSV file will be represented in your table - Create a SQL database and a SQL table in your MySQL server that will hold this data. - Import the CSV data into your MySQL sorvor. - Write a SQL script that adds the "amounts" column. You will submit your work as: - One SQL script (with a comment block that gives your name and the date of completion, etc.) that creates the database. - One other SQL script that uses your database and table to compute the sum of tho amounts column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!