It is small movie database. A smaller version of IMDB. If you want to run than first run .sql file in postgres tool than you can check query one by one and there one file .pgc is for console application that is just to run your query in Console Application.
Project Title: SMDB = Small Movie Database
In this ever increasing entertainment world, we need a database management system to store and retrive the data.
We also need to store the data efficiently, this database also needs to be user friendly so that users can retrive the data easily. We will not include TV Shows and Other Media Content (Images, Videos) in our database otherwise it will be a huge database in terms of size.
The database provides in depth detail of a movie which may be helpful to a user who is looking for a new movie to watch or to review a watched movie.
The database involves keeping record of movies, actors, charators, directors, producers, runtime, reviews, users, Box Office records, movies description, release date, genre, trivia, user watchlist, awards, other movie details.
Basically our movie database is similar to IMDB(International Movie Database) on a small scale.
movies of a specific actor/director/charator
reviews of a movie
movie ranking by user ratings
movies of a specific genre
awards received by an actor/movie/director/producer
movies premiering in the same location in the user lives
movies released in a specific year or time period
movies that earned more than a specific amount
trivia about a movie
movies that some actors(two or more) worked together in
cast of a movie