Overview

To complete this lab, go to your Codio virtual lab environment and start a new terminal session. Once there, perform the steps below to complete this activity. Manually enter any commands you are asked to write.

At the end of each step in the activity, replace the bracketed text with a screenshot, brief explanation, or both, as indicated. Size each screenshot and its explanation to fit about one$-$quarter of the page with the description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see an example of how screenshots for your assignment should look.

Create a Database

$1.$ Create a new database and update the name to your last name; then connect to it$.$ Type the following commands after the prompt mysql$>$:

A$.$ CREATE DATABASE last$\_$name$\_$here;

i$.$ For example, if your database is going to be named Jetson, then substitute "Jetson" for "last$\_$name$\_$here".

ii$.$ Press Enter.

B$.$ SHOW DATABASES;

i$.$ Press Enter.

ii$.$ You should see a listing of all of the databases $($or schemas$)$ in MySQL$,$ including the one you just created.

C$.$ USE last$\_$name$\_$here;

i$.$ Press Enter.

ii$.$ Substitute the name of your database $($for example, "Jetson"$)$ for "last$\_$name$\_$here". This SQL statement connects your MySQL session to the database you just created.

D$.$ Capture a screenshot of the results of this action.

$[$Insert screenshot here.$]$

$2.$ Create a table called tb$2$ and list out the tables in your database with one field by typing the following commands after the prompt mysql$>$:

A$.$ CREATE TABLE tb$2($user$\_$id VARCHAR$(50))$;

i$.$ Press Enter.

B$.$ SHOW TABLES;

i$.$ Press Enter.

C$.$ DESCRIBE tb$2$;

i$.$ Press Enter.

D$.$ Capture a screenshot of the results of this action.

$[$Insert screenshot here.$]$

$3.$ Add a second field into the table and describe it$.$ Do this by entering the following commands after mysql$>$:

A$.$ ALTER TABLE tb$2$ ADD newfield VARCHAR$(25)$;

i$.$ Press Enter.

B$.$ DESCRIBE tb$2$;

i$.$ Press Enter.

C$.$ Capture a screenshot of the results of this action.

$[$Insert screenshot here.$]$

$4.$ Organize your work to match the screenshot example and guidelines in the example document linked in the Supporting Materials section of the guidelines and rubric. Your submission should show that your work is original and the commands you have written for this lab worked correctly.