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: 448 Weeks 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 29 May 2017 My Price 8.00

Retrieve the names of all senior students majoring in ‘CS’

Specify the following queries in SQL on the database schema of Figure 1.2.

a. Retrieve the names of all senior students majoring in ‘CS’ (computer science). b. Retrieve the names of all courses taught by Professor King in 2007 and 2008.

c. For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section.

d. Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.

 

Figure 1.2

 

Answers

Alpha Geek
(8)
Status NEW Posted 29 May 2017 07:05 AM My Price 8.00

-----------

Attachments

file 1496045618-Answer.docx preview (285 words )
S-----------pec-----------ify----------- th-----------e f-----------oll-----------owi-----------ng -----------que-----------rie-----------s i-----------n S-----------QL -----------on -----------the----------- da-----------tab-----------ase----------- sc-----------hem-----------a o-----------f F-----------igu-----------re -----------1.2-----------. -----------a. -----------Ret-----------rie-----------ve -----------the----------- na-----------mes----------- of----------- al-----------l s-----------eni-----------or -----------stu-----------den-----------ts -----------maj-----------ori-----------ng -----------in -----------‘-----------CSâ-----------€™ -----------(co-----------mpu-----------ter----------- sc-----------ien-----------ce)-----------. b-----------. R-----------etr-----------iev-----------e t-----------he -----------nam-----------es -----------of -----------all----------- co-----------urs-----------es -----------tau-----------ght----------- by----------- Pr-----------ofe-----------sso-----------r K-----------ing----------- in----------- 20-----------07 -----------and----------- 20-----------08.----------- c-----------. F-----------or -----------eac-----------h s-----------ect-----------ion----------- ta-----------ugh-----------t b-----------y P-----------rof-----------ess-----------or -----------Kin-----------g, -----------ret-----------rie-----------ve -----------the----------- co-----------urs-----------e n-----------umb-----------er,----------- se-----------mes-----------ter-----------, y-----------ear-----------, a-----------nd -----------num-----------ber----------- of----------- st-----------ude-----------nts----------- wh-----------o t-----------ook----------- th-----------e s-----------ect-----------ion-----------. -----------d. -----------Ret-----------rie-----------ve -----------the----------- na-----------me -----------and----------- tr-----------ans-----------cri-----------pt -----------of -----------eac-----------h s-----------eni-----------or
Not Rated(0)