This project mimics the main functionalities of IMDB website. The goal of this project is to learn and practice SQL and database design.
- Created a raw-file-only data persistence solution with a Web UI for a movie-actor database using Blazor framework.
- Designed a relational database using ER modeling.
- Implemented ER models using SQL using advanced features including triggers and functions.
- install dotnet core 3.1 runtime (or sdk)
- windows only: run P0.UI.exe linux, mac, windows: in terminal: dotnet P0.UI.dll
- open browser and open url printed on console (default: http://localhost:5000)
- Compiled & ready-to-run version of the project is located at "Publish" directory
- All data files are located at "Data/DB" directory. There is a back-up just in case. Do not edit it.
- A set of mock & completely random dataset have been provided. Check the formatting of each file and change it (if you want) very carefully.
- UI: You can double click on each table row to see full detail of any record
- UI: Search bar & sorting features of tables are processed at client side. Input textboxes below the tables are meant for satisfying the goals of the project according to the given doc.
- To walk through & debug the code VisualStudio 2019 is the recommended IDE.
- The web framework: Blazor
- The UI framework: Radzen
Run the files in the following order: (ignore any error)
- drop.sql
- tables.sql
- views.sql
- functions.sql
- triggers.sql
- insert.sql
There is a set of prepopulated sql insert query files in the "pre" directory howerver, if you want to regenerate the data do the 7th step otherwise skip it
- random_data_gen.py (new sql files will be replaced in "pre" directory)
- pre/post.sql (be patient :))
- pre/**.sql (order doesn't matter)
Then run each query from "queries.sql" file to see the results. (some of the results could be empty due to lack of data which satisfies the constraints)
Feel free to add data or run custom query in the console.