This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Query 4 : Displays all information about the movie: ‘Harry Potter and the Sorcerer’s Stone’ Query 5 : Displays the names of the actors and the characters they played for ‘Harry Potter and the Sorcerer’s Stone’. Query 6 : Displays all user reviews that exist for ‘Harry Potter and the Sorcerer’s Stone’. Query 7 : Displays information about the actor ‘Richard Harris’. Query 8 : Displays all the movies and the characters that ‘Richard Harris’ played. Query 9 : Displays information about the character ‘Albus Dumbledore’. Query 10 : Displays a list of movies the character ‘Albus Dumbledore’ appeared in and the actors that played the character in the that movie. Query 11 : Adds a new record into the Table Member Query 12 : Adds new record into the table FavoriteMovie Query 13 : Updates a specific record of the FavoriteMovie Table Query 14 : Displays all the reviews written by a specifc user...
View Full Document
This note was uploaded on 03/11/2010 for the course MIS 3400 taught by Professor N/a during the Spring '10 term at Uni. Münster.
- Spring '10