DBA$120$ MySQL Practice $($Extra credit$)$

IMPORTANT:

You must complete the project with MySQL$.$ You must test your work before submitting it for

grading. Assignments completed on a database other than MySQL will get a zero $(0)$ grade. You

can use NetLab in CPCC virtual environment or any MySQL to complete the assignment.

Instructions on how to use Netlab can be found in Brightspace.

DELIVERABLES $($must submit both$)$:

A text file with all your $SQL$ commands. If not submitted, you will get a zero for the assignment.

A Word file with a MySQL workbench sereenshot for each task. This includes your code and the

result. If not submitted, you will get a zero for the assignment.

TASKS to Complete:

Create a database named mySQL firsthame your lastname. For example, if your name is John

Smith, the database name must be mySQL$\_$JOHN$\_$SMITH. Use this database to complete all of

the following tasks. See below:

CREATE DATABASE mySQL$\_$your firsthame$\_$your lasthame;

Type the following statements and display the results.

USE mySQL$\_$your firstname$\_$your lastname;

SELECT current$\_$user$(),$ now $(),$ database$()$;

Type the following command to create a table with your name.

CREATE TABLE ex$\_$your firstname your lastname

$($ ID integer primary key,

FNAME varchar$(25),$

LNAME varchar$(25))$;

Type the following command to display the structure of the table.

DESCRIBE ex$\_$your firsthame$\_$your lastname;

Type the following command to insert a record $($with your first and last name$)$ into the table $e{x}_{-}$

your firstname your lastname.

INSERT INTO ex$\_$your firsthame$\_$your lasthame

VALUES $(100,$ 'your firstname', 'your lastname'$)$;

Type the following command to display the records from the table ex$\_$your firstiame$\_$your

lastname.

SELECT $*$ FROM ex$\_$your firstname$\_$your lastname;