Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DBA 1 2 0 MySQL Practice ( Extra credit ) IMPORTANT: You must complete the project with MySQL . You must test your work before
DBA 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 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 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 mySQLJOHNSMITH. Use this database to complete all of
the following tasks. See below:
CREATE DATABASE mySQLyour firsthameyour lasthame;
Type the following statements and display the results.
USE mySQLyour firstnameyour lastname;
SELECT currentuser now database;
Type the following command to create a table with your name.
CREATE TABLE exyour firstname your lastname
ID integer primary key,
FNAME varchar
LNAME varchar;
Type the following command to display the structure of the table.
DESCRIBE exyour firsthameyour lastname;
Type the following command to insert a record with your first and last name into the table
your firstname your lastname.
INSERT INTO exyour firsthameyour lasthame
VALUES 'your firstname', 'your lastname';
Type the following command to display the records from the table exyour firstiameyour
lastname.
SELECT FROM exyour firstnameyour lastname;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started