Exaplnation - Query 4 : Displays all information about the...

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

View Full Document Right Arrow Icon
The seven tables that were created in this assignment were based on the corresponding entities in ERD provided. Following is the brief description of each table: Member : This table is used for storing site member information Movie : This table is used for storing movie information Actor : This table is used for storing actor information Review : This table stores movie reviews written site members FavoriteMovie : This table is used for storing site users favorite movies MovieCharacter : This table contains movie character information ActorCharMovie : This table is used to store the relationship info between Actors, Movie Characters and Movies. Given below is the brief description of the task each query does : Query 1 : Lists the movies for the current week, showing the movie name and movie’s revenues for that week. Query 2 : Displays the result of the search for movie title using ‘Harry Potter’. Query 3 : Displays the result of the search for actor names using ‘Harry Potter’
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

Exaplnation - Query 4 : Displays all information about the...

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