cgs1540-lab2
.docx
keyboard_arrow_up
School
University of South Florida *
*We aren’t endorsed by this school
Course
ITS4114
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
7
Uploaded by SargentChinchilla690
CGS 1540
Lab 2
In this activity, you must use the
MySQL Command Line
. Do
not
use Workbench.
You'll need to take screenshots of the MySQL Command Line Client window throughout the
assignment.
o
It is strongly recommended to use the
'Snipping Tool'
or
'Snip and Sketch'
(on Windows) ,
or
'Grab'
(on MacOS).
These tools allow you to select a small rectangle of your screen, containing
only the
area needed.
This selected area is "snipped" to the clipboard and can be pasted directly into Word.
There is no need to save the snip as a separate file on your hard drive. Just paste it
into this Word document (and save this document often).
If you take a screenshot of the full screen, you'll have to crop it later.
o
Do not take pictures of the screen with a camera/phone as it can be very hard to read
(blurry/glare/small), and more time-consuming for you than the above tools.
o
All your images (screenshots) must include only the requested command and results, showing
in your MySQL command line.
We need to see both the command and the results
(not one
or the other). Please do not include the previous steps or errors you made along the way -
include only the requested content for each image.
o
Here's a sample screenshot:
o
Note that the screenshots must follow their respective assignment instructions, in the correct
order, and the font is clear, easy to read (not too small or blurry).
Important
: Take screenshots as you go. Do not wait until you are done with all steps before taking
the screenshots, because if your command-line window suddenly crashes, you will not have
screenshots of the steps you already did (and you'll have to start over). The tables are saved from
session to session, but the command history is not.
Again, all of the steps must be done in the MySQL Command Line.
Page
1
of
7
CGS 1540
Lab 2
Perform the following steps in order. Some steps are repeated on purpose.
Open the MySQL Command Line Client. Enter your password.
1.
The first query you must do is :
SELECT NOW();
For the next items, run SQL commands to perform exactly what is requested.
2.
List the names of your existing databases.
Page
2
of
7
CGS 1540
Lab 2
3.
Create a
database
named
labs
.
Use this new database for the next steps.
4.
Create a
table
of movies. The table name
must be
:
movie
. The columns are named:
title
,
year,
duration
,
gross
.
The column
title
must support up to 80 characters – so it can store the name of a movie.
The column
year
must use data type INT – so it can store the release year for the movie.
The column
duration
must use data type INT – so it can store the length of the movie (in
minutes).
The column
gross
must use data type DEC(6, 1) – so it can store the box office earnings (in
millions).
You are only
creating
the table
movie
in this step – do not insert any movies in the table yet.
Page
3
of
7
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help