354.3-08.SolutionExtra

354.3-08.SolutionExtra - CMPT-354 D1 Fall 2008 Instructor:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CMPT-354 D1 Fall 2008 Instructor: Martin Ester TA: Gustavo Frigo Solution Extra Assignment Introduction This is an extra practical assignment using SQL Server 2005 Management Studio to give you more practical experience. Please, do NOT submit your solution, since it will not be marked. In this assignment, you will work on the Movie database, consisting of the following tables: MovieList(title:string , year:int) Note that the year of the release is also added as suffix to the title. Actors(actorName: string, actedIn:string ) actedIn is FK to MovieList, actorName has the format “lastName,firstName”. Actresses(actressName: string, actedIn:string ) actedIn is FK to MovieList , actressName has the format “lastName,firstName”. Genres(title:string,genre:string) title is a FK to MovieList Keywords(keyword:string, movieTitle:string) movieTitle is a FK to MovieList TopMovies(distribution:char(10), votes: int, rank: float, title: string ) title is a FK to MovieList WorstMovies(distribution:char(10), votes: int, rank: float, title: string ) title is a FK to MovieList Formulate the following queries in SQL. Where applicable, make sure that you return only distinct
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2009 for the course CS 12601 taught by Professor Kewang during the Spring '09 term at Simon Fraser.

Page1 / 3

354.3-08.SolutionExtra - CMPT-354 D1 Fall 2008 Instructor:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online