About This project is part of the Databases Course. The project is a stadium management system which is designed to keep track of all tickets, fans, clubs, and matches
The Project aims to manage everything related to the football cycle starting from a fan who wants to attend matches by purchasing some tickets then moving to the club representative who can ask for host request for his / her club, host requests are handled by the stadium manager who can accept or reject the request coming from a certain club representative. Furthermore, the system also contains a Sport Association Manager who can add new matches to the schedule and of course the System Admin who can block fans, add or delete stadiums and clubs.
1) We Designed The Database EERD diagram on which the whole system was built. 2) We were able to translate the schema of the EERD to SQL Tables and Queries. 3) The Relational Database Management System is built using MSSQL. 4) The backend was done using C# and ASP.NET Framework. 5) Frontend was build using HTML,CSS and JavaScript.