Fall Semester 2007


Project Notes: Rotten Tomatoes.
I gave myself a couple of exercises last time, here are some answers.

Let me first explain there is a site I am trying to emulate (in some scaled-down sense).

Let me start being more specific on the data.

1. We need a few movies.

My movies:

2. Each movie is rated by a person.

My people:

In terms of rating, the users will produce this:

lbird tkukoc mjackson mjordan cmullen jrose
ryan1998 100 92
spongebo 92 10 80
johnnyEn 20 95 68 92
incredib 92
princess 82 68
nglishpt 80 60
reignovr (*)

Regarding (*) above:

Earlier we asked the following questions:

My current answers to these questions:

Earlier we asked the following questions:

My current answers to these questions:

Earlier we asked the following questions:

My current answers to these questions:

This exercise (I will solve it next time) will help us extract information.

Write SQL code to retrieve:

This is what we need (for now) from this website.


Last updated: Oct 2, 2007