160 likes | 358 Views
Database Project. Melanie Carden LS 560 - Spring 2013. Current Website.
E N D
Database Project Melanie Carden LS 560 - Spring 2013
Current Website IMDb is an online database of information related to films, television programs, and video games. This includes actors, production crew personnel, and fictional characters featured in these three visual entertainment media.
Did you know? A vast majority of movies are inspired by books
Inquiring Minds • Most library patrons would like to know... • Which movies are based on books? • Which books are about to go into movie production? • This interest is based on the fact that most library patrons would like to read the book before it is released to theaters. • Also, teachers and librarians would like to be able to compare the book to the film for educational purposes.
Database Concept • Are there recurring elements between this relationship?? • Examples: • From the amount of movies that are based from books, how many have won an Oscar? • Furthermore, had any of those books won awards on their own? • Do any of the movies have the same Director?
Table #1 - Base Information 21 movies were chosen from the last 10 years of production & listed with the following information: Release Year Title Director Rating Oscar? Based on book? Book Title Author Publication Year Reading Level Award Winner? Name of Award
Table #2 - Reading Level This table sorts the books by reading level: Children Young Adult Adult
Table #3 - Movie Rating Level This table sorts the movies by rating level: G PG PG-13 R
Relationships The main list has been connected to the movie rating table and book rating table
Possible IMDb Feature Feature in the Movie drop-down menu: "Inspired by Books"
Query #1 Movies inspired by award-winning books
SQL - Query #1 SELECT [Main List].[Movie Title], [Movie Rating].[Movie Rating Level], [Main List].[Based on book], [Main List].[Title of Book], [Main List].[Award Winner], [Main List].Award FROM [Main List] INNER JOIN [Movie Rating] ON [Main List].[Movie Rating] = [Movie Rating].[Movie Rating Level] WHERE ((([Movie Rating].MovieID)=2) AND (([Main List].[Award Winner])=True));
Query #2 Oscar winning movies that were based on books
SQL - Query #2 SELECT [Main List].[Movie Title], [Main List].[Based on book], [Main List].[Title of Book], [Book Rating].[Reading Level], [Main List].[Oscar Winner] FROM [Main List] INNER JOIN [Book Rating] ON [Main List].Level = [Book Rating].[Reading Level] WHERE ((([Main List].[Based on book])=True) AND (([Book Rating].LevelID)=3) AND (([Main List].[Oscar Winner])=True));
Query #3 - Specific Search Scorsese movies... Were any based on books? Won an Oscar? Or both?
SQL - Query #3 SELECT [Main List].[Movie Director], [Main List].[Movie Title], [Main List].[Based on book], [Main List].[Oscar Winner] FROM [Main List] WHERE ((([Main List].[Movie Director])="Martin Scorsese"));