Skip to content

Latest commit

 

History

History
24 lines (20 loc) · 948 Bytes

README.md

File metadata and controls

24 lines (20 loc) · 948 Bytes

imdb-database-model

Designed and populated IMDB database in MSSQL, Oracle and MySQL using Toad Data Modeler to return results of searches by user, write reviews and vote for polls
View Data Model

Running the example

For MS-SQL

1) Run the MSSQLIMDB.sql script file to create table and add dependencies of foreign keys and other relations
2) Insert all data in the Data folder either by importing from excel file or by running insert queries
3) Run triggers and stored procedures from the Triggers folder
4) Run select queries from views folder to see appropriate results and test the triggers and other dependencies

For Oracle

1) Run the OracleIMDB.sql script file instead of MSSQLIMDB.sql to create tables
Steps 2 to 4 are similar to MS-SQL

Authors

  • Vighnesh Venkatakrishnan
  • Naini Shah
  • Fiona Lobo