hw1 - CIS 450/550 Database and Information Systems Fall...

This preview shows page 1 - 3 out of 4 pages.

CIS 450/550Database and Information SystemsFall 2016Homework 1 (Upload to Canvas by 23:59:59 EDT onSeptember 21)Please submit this homework electronically using Canvas (under hw1).Readthe SQL lecture slides as well as what was assigned on the syllabus page (textbookchapters and “SQL for Web Nerds”).The goal of this homework is to get experience with two relational databases, Oracle(running on Amazon’s AWS/RDS ) and mySQL (running on fling.seas.upenn.edu, or youcan set up your own local instance).The database you will use for the first part of the homework consists of a portion theInternet Movie Database (IMDB.com). It has been uploaded to Amazon’s AWS/RDS andconforms to the following schema (where keys are underlined):actors(id:int,firstname:string,lastname:string,gender:string)directors(id:int,firstname:string,lastname:string)directorsgenres(directorid:int,genre:string,prob:float)movies(id:int,name:string,year:int,rank:float,)moviesdirectors(directorid:int,movieid:int)moviesgenres(movieid:int,genre:string)roles(actorid:int,movieid:int,role:string)1. (5 pts) Usingsqlplusrunning on Eniac (or other SQL clients such as SQLDeveloper)connect to the Oracle instance IMDb that we have set up (read theRDSHandout.docin thehw1folder on Canvas).Then find the names of the first five movies that occur in the tablemoviesby runningthe querySELECT M.nameFROMmovies MWHERE ROWNUM < 5;Copy these names in a filehw1-1.txtand submit this file using Canvas.1
The next eight exercises ask you to write queries in SQL. Your answers will consist ofthe query itself (andnotof the answers returned by the queries). Obviously you shouldrun the queries to see that they work correctly. Since the dataset is rather large, you

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
ZacharyIves
Tags
pts, Films considered the greatest ever, Internet Movie Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture