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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions