354.3-08.Assignment5

354.3-08.Assignment5 - 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 Assignment 5 Total marks: 100 (10 % of the assignments) Due date: October 24, 2008 Introduction This is a practical assignment using SQL Server 2005 Management Studio. Please, submit your solution in electronic form by email to the TA. In this assignment, you will create and load your own Movie database, consisting of the following tables: Movies(title:string , year:int) Note that the year of the release is also added as suffix to the title. Actors(actedIn:string, name:string ) actedIn is FK to Movies. Actresses(actedIn:string, name:string ) actedIn is FK to Movies , name has the format “lastName,firstName”. Genres(movie:string,genera:string) movie is a FK to Movies Keywords(movie:string,keyword:string) movie is a FK to Movies PopularMovies(movie:string, voteDistribution:char(10), voteCount:int, rank:int) PopularMovies contains the 250 most popular movies. Distribution is a string of fixed length showing the distribution of votes. The vote distribution uses a single character to represent the
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.

Page1 / 2

354.3-08.Assignment5 - 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