MoviesOnBooks is a website which features all movies based on books eg. Harry Potter, A beautiful mind, etc. It is a platform where users can query books or, and movies. The query result contains inormation about actors, graphics, characters, comics etc.; All this information has been crawled from the web.
This database was created on PostgreSQL and webcrawling was done using PHP.
The interface is interactive and keeps track of top rated movies and books based on user past search (deployed using tiggers and procedures).
This repository contains triggers, procedures and other SQL commands, used to develop this web page.