MiteshPuthran / IMDB-Database-Modelling-and-Analysis Public

Notifications You must be signed in to change notification settings
Fork 2
Star 2

Modeled sample movie database(IMDB) using Toad Data Modeler, implemented various queries, triggers and stored procedure in MS-SQL, Oracle, Hive and generated Tableau reports for the same

2 stars 2 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
DATABASE		DATABASE
ERDiagram		ERDiagram
HIVE Queries		HIVE Queries
MS SQL Queries		MS SQL Queries
ORACLE Queries		ORACLE Queries
TABLEAU Reports		TABLEAU Reports
IMDB DATA-20170311T172008Z-001.zip		IMDB DATA-20170311T172008Z-001.zip
README.md		README.md

Repository files navigation

IMDB-Database-Modelling-and-Analysis

Using Toad Data Modeler, modeled sample IMDB database and implemented the database in MS-SQL, Oracle and Hive with dummy data.

Created various queries, triggers, stored procedure to implement various solutions on all three databases.

Generated Tableau reports to display top rated movies, top genre, movie production language, popular showtimes etc.

About

Modeled sample movie database(IMDB) using Toad Data Modeler, implemented various queries, triggers and stored procedure in MS-SQL, Oracle, Hive and generated Tableau reports for the same

Report repository

Releases

No releases published

Packages

No packages published