Running Head: FINAL PROJECT
DAD-220 Final Project
Christopher T. Gouchenouer
DAD-220 Introduction to SQL
Professor Robinson
8/19/2018
FINAL PROJECT
For this project, we were instructed to work out of the messaging database so the first thing that
we were to do is load the correct database.
ietp,
netp
nysql> USE messaging; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed
In Task # 1, we were required to insert a record into the person table using ourselves as the
person entered. With that requirement, I had entered inserted the person_id of "7, the first_name
of "Christopher" and the last name of "Gouchenouer" into the person table with the following
statement.
mysql> INSERT INTO person (person_id, first_name, last_name) -> VALUES -> (7, "christopher", "Gouchenouer"); Query 0K, 1 row affected (o.03 sec)
FINAL PROJECT
The results of the above statement are shown in the image below
SFITO
FROM
DeFson.
name
ame
edecky
Allyson Kevin Diana Christopher
LX
Taurasi Gouchenouer
OWS
set (o.00 sec)
In Task # 2, we were instructed to alter the person table by adding an additional column of our
choice. I chose to add the birth_year column with the year data type making it not null. The
statement for this task is shown below.
mysql> ALTER TABLE person ADD birth_year YEAR(4) NOT NULL; Query 0K, 7 rows affected (o.23 sec) Records: 7 Duplicates: o Warnings: o
The results of the above statement are shown below.