Creating and Altering Tables for employees…
Stuck with a difficult assignment? No time to get your paper done? Feeling confused? If you’re looking for reliable and timely help for assignments, you’ve come to the right place. We promise 100% original, plagiarism-free papers custom-written for you. Yes, we write every assignment from scratch and it’s solely custom-made for you.
Order a Similar Paper Order a Different Paper
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:
Creating-and-….doc
We’ve proficient writers who can handle both short and long papers, be they academic or non-academic papers, on topics ranging from soup to nuts (both literally and as the saying goes, if you know what we mean). We know how much you care about your grades and academic success. That's why we ensure the highest quality for your assignment. We're ready to help you even in the most critical situation. We're the perfect solution for all your writing needs.
Get a 15% discount on your order using the following coupon code SAVE15
Order a Similar Paper Order a Different Paper
