Compare the performance of different queries in PostgreSQL against the IMDb dataset with and without indexing.
1.1 Real database of IMDb movies.It contains 7 tables. It contains details of several relation between movies, directors, genre, actors and roles.
1.2 Source Link: https://relational.fit.cvut.cz/dataset/IMDb
1.3 Drive link for Preprocessed file: https://drive.google.com/drive/folders/15w7b6ar95Ilu1CY50FdT_DxlxV0Uq11X?usp=sharing
2.1 To design an ER Model for a real-world dataset and translate into SQL schema.
2.2 To populate data into database using DML statements.
2.3. To write SQL queries.
2.4. To deploy indexing into database.
2.5. To measure the performance of SQL queries with and without indexing
For more details, please refer to the attached project report.
