faiyaz106 / query-performance-comparison-in-postgresql Goto Github PK

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.