Homework #1 (due 02/17/11)

img
Pdf Available

2 pages - 98.4 KB

1.3: find all the actors that starred in all movies starring harrison ford. write the following queries in sql: • 1.4: for every actor, list the actor and ...

DownloadPrintView FileLoad Full
/ 0
60%
Table of contents
/ 0
60%

Document in text mode:

CSE562:Homework#1(due02/17/11)Youaregiventhefollowingrelationalschema:MOVIE(TITLE,DIR,YEAR,BUDGET)CAST(TITLE,ACTOR).Keysareunderlined.TheattributeTITLEinCASTisaforeignkeyreferencingMOVIE(TITLE).Problem1(24pts)WritethefollowingqueriesinrelationalalgebraandSQL:•1.1:FindallthedirectorsofthemoviesstarringHarrisonFord;•1.2:Findalltheactorsthatstarredin“StarWars”butnotin“ReturnoftheJedi”;•1.3:FindalltheactorsthatstarredinallmoviesstarringHarrisonFord.WritethefollowingqueriesinSQL:•1.4:Foreveryactor,listtheactorandthenumberofmovieshe/shemadeunderthedirectionofStevenSpielberg;•1.5:Findalltheactorswiththehighestnumberofmovieswhosebudgetwasovertheaveragemoviebudget.Problem2(8pts)YouaregivenarelationschemaCONNECTION(ORIGIN,DESTINATION,AIRLINE)representingairlineconnec-tions.WritethefollowingqueriesinSQL,possiblyusingrecursion:•2.1:Foreverycity,findthenumberofcitiesconnectedtoitusingasingleairlinewithatmostonestopover.Theconnectionsmaybeindirect.•2.2:FindallthecitiesconnectedtoBuffalousingarbitrarya...

Load more Show less

Relevant files:

  • Unifi tv
    img
    Pdf Available

    2 pages - 261.6 KB

    Of hits and hits movies on unifi tv, telekom malaysia berhad's (tm) content ... movies starring robert redford (all the president's men), harrison ford (the ...

    7638
  • Engl v144
    img
    Word Available

    3 pages - 45.5 KB

    Course goals and objectives: this course is intended to help students “read” movies and, in the case of the movies of harrison ford, to understand the way ...

    5184
  • 雪隆八独中电脑工作营
    img
    Pdf Available

    18 pages - 602.1 KB

    Harrison ford. mighty ducks. 1991. 104. color. disney. emilio estevez. wrong movies. 30. anomalies. • what's wrong with the “wrong movies” ...

    8492
  • What do human evolution, leukemia treatment, database design (and a ...
    img
    Pdf Available

    12 pages - 572.4 KB

    Harrison ford. mighty ducks. 1991. 104. color. disney. emilio estevez. wrong movies. 29. anomalies. • what's wrong with the “wrong movies” ...

    9792
  • Sql queries ii
    img
    Pdf Available

    50 pages - 1.3 MB

    5. find the distinct names of producers of movies where. harrison ford starred without using distinct. select name. from movieexec.

    9776
  • Databases & sql
    img
    Pdf Available

    18 pages - 313.2 KB

    Figure 7.2: a database containing a single table called “movies” storing the ... listing 7.19 finding all movies that harrison ford did not appear in.

    8012

Topics related: