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

  1. 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

Attachments:

Writerbay.net

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