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

  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:

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.