You own a restaurant and need to create for employees. For thisassignment, you will create a table then alter it
-
Create a database called art_and_soul
Create a table called employees using the information below
CREATE TABLE tasks (
id INT(11) N0T NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR (255) NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL);
3. Insert The values from the table into the employees.
When you’re done select all columns and copy the table to a notepad file and save it as “Your name Creating and Altering Tables part 1”
first_name
|
last_name
|
email
|
Your First Name
|
Your Last Name
|
Your Email
|
Dakota
|
Moxey
|
dakotamoxey@gmail.com
|
Inara
|
Miller
|
inaravmiller@gmail.com
|
Brentae
|
Clarke
|
robynmcphee83@gmail.com
|
Shantae
|
Smith
|
tny385625@gmail.com
|
Maygen
|
Daley
|
adiadaley@adiadaley.com
|
Dearje
|
Mckinney
|
Dearjemckinney15@gmail.com
|
Michael
|
Etienne
|
mjstunner4@hotmail.com
|
D’andre
|
Brown
|
browndandre02@gmail.com
|
Raheem
|
Stubbs
|
raheemstubbs@gmail.com
|
Ashton
|
Cartwright
|
Ashtoncartwright242@gmail.com
|
D’Nia
|
Walker
|
niawalker2303.dcw@gmail.com
|
Ta’Nage
|
Bowleg
|
nagiilove_1094@yahoo.com
|
Shiloh
|
Mills
|
shilohnuub22@gmail.com
|
Miguel
|
Miller
|
luthermm1976@gmail.com
|
Antonique
|
Greenslade
|
agreenslade101@gmail.com
|
Torian
|
Carey
|
torian.j.carey242@gmail.com
|
Chenyah
|
Evans
|
nyah6105@gmail.com
|
Phillip
|
Swann
|
pswannnn@gmail.com
|
Hannah
|
Minns
|
m12345minns@hotmail.com
|
Brianna
|
Smith
|
briannasmith0413@outlook.com
|
A.Kristin-Grace
|
Braynen
|
almaldreakg@gmail.com
|
Kameron
|
Taylor
|
kamtay900@gmail.com
|
Donajuan
|
Richards
|
djrichards242@gmail.com
|
Serenity
|
Meronard
|
serenityme22@gmail.com
|
Delano
|
Archer
|
archerd@btvi.edu.bs
|
4. Alter The table then add phone and job_title after last_name.
phone varchar(10) Null,
job_title varchar(15) not null
5. Take a screenshot of the command and a screenshot of your table and save it as “Your name Creating and Altering Tables part 2″
6. Insert these values in phone, email, job_title.
Phone Number
|
job_Title
|
Your Phone Number
|
Owner
|
565-0981
|
bus person
|
525-0376
|
Executive chef
|
525-9812
|
bus person
|
814-2145
|
manager
|
812-1945
|
bus person
|
816-1928
|
Human resources manager
|
812-5476
|
bus person
|
545-2288
|
custodian
|
532-1198
|
bus person
|
812-4345
|
Human resources manager
|
565-1254
|
bus person
|
818-5486
|
bus person
|
454-0987
|
bus person
|
341-8625
|
manager
|
525-4689
|
cook
|
341-8534
|
bus person
|
346-1175
|
Executive chef
|
321-3478
|
bus person
|
335-0339
|
custodian
|
335-1823
|
bus person
|
814-9471
|
cook
|
321-2284
|
custodian
|
345-8310
|
cook
|
814-0145
|
cook
|
565-1230
|
cook
|
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"