Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 345 Weeks Ago, 5 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Programming Posted 02 May 2017 My Price 5.00

Write an ALTER statement to add the column Area

a. Write an ALTER statement to add the column Area Code to EMPLOYEE. Assume that Area Code is not required.

b. Write an ALTER statement to remove the column Area Code from EMPLOYEE.

c. Write an ALTER statement to make Phone an alternate key in EMPLOYEE.

 

d. Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE.

Answers

Alpha Geek
(8)
Status NEW Posted 02 May 2017 06:05 PM My Price 5.00

-----------

Attachments

file 1493749406-answer1.docx preview (74 words )
a-----------. W-----------rit-----------e a-----------n A-----------LTE-----------R s-----------tat-----------eme-----------nt -----------to -----------add----------- th-----------e c-----------olu-----------mn -----------Are-----------a C-----------ode----------- to----------- EM-----------PLO-----------YEE-----------. A-----------ssu-----------me -----------tha-----------t A-----------rea----------- Co-----------de -----------is -----------not----------- re-----------qui-----------red-----------. -----------b. -----------Wri-----------te -----------an -----------ALT-----------ER -----------sta-----------tem-----------ent----------- to----------- re-----------mov-----------e t-----------he -----------col-----------umn----------- Ar-----------ea -----------Cod-----------e f-----------rom----------- EM-----------PLO-----------YEE-----------. -----------c. -----------Wri-----------te -----------an -----------ALT-----------ER -----------sta-----------tem-----------ent----------- to----------- ma-----------ke -----------Pho-----------ne -----------an -----------alt-----------ern-----------ate----------- ke-----------y i-----------n E-----------MPL-----------OYE-----------E. ----------- d.----------- Wr-----------ite----------- an----------- AL-----------TER----------- st-----------ate-----------men-----------t t-----------o d-----------rop----------- th-----------e c-----------ons-----------tra-----------int----------- th-----------at -----------Pho-----------ne -----------is -----------an -----------alt-----------ern-----------ate----------- ke-----------y i-----------n E-----------MPL-----------OYE-----------E. ----------- An-----------swe-----------r -----------The----------- de-----------sir-----------ed -----------sta-----------tem-----------ent-----------s a-----------re -----------as -----------wri-----------tte-----------n b-----------elo-----------w: ----------- AL-----------TER----------- TA-----------BLE----------- EM-----------PLO-----------YEE----------- AD-----------D
Not Rated(0)