Creating and Altering Tables for employees…
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 |
|
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 |
Attachments: