Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
csv table
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions