1 / 16

Database Project

Database Project. Melanie Carden LS 560 - Spring 2013. Current Website.

jena-jones
Download Presentation

Database Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Project Melanie Carden LS 560 - Spring 2013

  2. 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.

  3. Did you know? A vast majority of movies are inspired by books

  4. 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.

  5. 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?

  6. 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

  7. Table #2 - Reading Level This table sorts the books by reading level: Children Young Adult Adult

  8. Table #3 - Movie Rating Level This table sorts the movies by rating level: G PG PG-13 R

  9. Relationships The main list has been connected to the movie rating table and book rating table

  10. Possible IMDb Feature Feature in the Movie drop-down menu: "Inspired by Books"

  11. Query #1 Movies inspired by award-winning books

  12. 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));

  13. Query #2 Oscar winning movies that were based on books

  14. 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));

  15. Query #3 - Specific Search Scorsese movies... Were any based on books? Won an Oscar? Or both?

  16. 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"));

More Related