Fall Semester 2007


Project Notes: Rotten Tomatoes.
Consider a website that alows users to comment on, and rate, movies:


Our job is to set up such a site.

What do we need?

1. A list of movies; suppose at this time the movies above are all we got.

(MovieNum, Description, Category, Year, (ActorNum, Last Name, First Name), 
                                        (DirectorNum, Last Name, First Name))
Exercise: write the data for the six movies above in the format indicated.

2. Each movie is rated by a person.

(MovieNum, Description, Category, Year, (ActorNum, Last Name, First Name), 
                                        (DirectorNum, Last Name, First Name), 
                                        (Username, Last Name, First Name, Comment, Rating))
Exercise: invent some users, let them comment, rate the movies.

Questions:

Example: how do we plan to add this movie to the database?

Questions:

Exercise: invent a new user, add the user to the database.

Let the user review some of the movies, perhaps including the new one.

Questions:

Exercise: write SQL code to retrieve:

Implement this in CGI/Perl or PHP. Which would be easier, better, more appropriate?


Last updated: Oct 1, 2007