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, 4 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 > Computer Science Posted 28 Apr 2017 My Price 5.00

Write SQL data definition commands for each of the following queries

 

Write SQL data definition commands for each of the following queries:

 

a. How would you add an attribute, Class, to the Student table?

b. How would you remove the Registration table?

c. How would you change the FacultyName field from 25 characters to 40 characters?

 

 

 
 

Answers

Alpha Geek
(8)
Status NEW Posted 28 Apr 2017 09:04 AM My Price 5.00

-----------

Attachments

file 1493372168-Answer.docx preview (64 words )
W-----------rit-----------e S-----------QL -----------dat-----------a d-----------efi-----------nit-----------ion----------- co-----------mma-----------nds----------- fo-----------r e-----------ach----------- of----------- th-----------e f-----------oll-----------owi-----------ng -----------que-----------rie-----------s: ----------- a.----------- Ho-----------w w-----------oul-----------d y-----------ou -----------add----------- an----------- at-----------tri-----------but-----------e, -----------Cla-----------ss,----------- to----------- th-----------e S-----------tud-----------ent----------- ta-----------ble-----------? -----------b. -----------How----------- wo-----------uld----------- yo-----------u r-----------emo-----------ve -----------the----------- Re-----------gis-----------tra-----------tio-----------n t-----------abl-----------e? ----------- c.----------- Ho-----------w w-----------oul-----------d y-----------ou -----------cha-----------nge----------- th-----------e F-----------acu-----------lty-----------Nam-----------e f-----------iel-----------d f-----------rom----------- 25----------- ch-----------ara-----------cte-----------rs -----------to -----------40 -----------cha-----------rac-----------ter-----------s? ----------- -----------  ----------- Se-----------p 1-----------7 2-----------016----------- 03-----------:25----------- PM----------- A-----------nsw-----------er:----------- -----------The----------- de-----------sir-----------ed -----------SQL----------- qu-----------eri-----------es -----------are----------- as----------- gi-----------ven----------- be-----------low-----------: ----------- a.----------- al-----------ter----------- ta-----------ble----------- ST-----------UDE-----------NT -----------add----------- Cl-----------ass----------- va-----------rch-----------ar(-----------25)-----------; S-----------amp-----------le -----------out-----------put-----------: b----------- -----------
Not Rated(0)