Database Systems Project. This is the 2021-2022 fall semester CEID Database Systems Project (TV On Demand): The source code includes the SQL code (Database Creation & Expansion, Data Insertion, Stored Procedures and Triggers) and the Java code (Implementing connection to the database, data fetching from the database and the necessary graphical interface).
We implement a TV On Demand system, where a customer can purchase a film or rent a tv series through a graphical interface. Customers can also edit their profile, make payments, view available content, view their rentals and change the type of their subscription. The system also supports different types of users such as Employees and Admin. Employees can view analytics about the sales of the system, view and edit customer info and modify the film and series inventory. Finally, the Administrator can promote or demote employees, view analytics, create or delete customer and employee accounts. Most of the analytics is calculated on the backend which uses the database's stored procedures and triggers.