IST $210-$ Lab $2$

Objective $-$ Create the music database and song table using SQL and load in Bulk Data.

Introduction $-$ You are creating the music$\_$basic table in the music database which will contain simple information about a variety of different songs. The database and table need to be created and filled with data. There is a file

music$\_$basic$\_$dataset.csv that contains all of the song information to be loaded into the music$\_$basic table. Include a screenshot of each step.

Hints:

music$\_$basic$\_$dataset.csv contains data that will be loaded into the database. Look at this data for help determining the type of each column.

Remember to set the database you are currently working with as your default schema

Include all screenshots in a single word document with headers for each step

Required Screenshots

Include screenshots of the completed table and database creation, include action output

Include screenshot$($s$)$ of the SQL statements used with the action output

Include screenshot$($s$)$ of the SQL statements used with the action output

Include screenshot$($s$)$ of Configure Import Settings and Import Results

Include screenshot$($s$)$ of the output and the SQL statement used.

Total Screenshots: $5$

Steps:

Create the music database and music$\_$basic table using the wizard. Make sure to name the data base beginning with your last name $($e$.$g$.$ Ocker$\_$music$\_$basic$)$

Include screenshots of the completed table and database