Group Project for CS306 Database Systems course in Sabancı University.
Database management system in order to help the Olympic games committee to regulate the Olympic games. Our database management stores information about the following entities; countries, athletes, managers, coaches, jury, medical service, technical service, transportation, audience, venue, and competitions. When a member of the Olympic committee enters the interface of our database, they will be able to reach out to every piece of the required information. Additionally, we display the relationships between these entities and their attributes.
While creating our database management system we used MySQL. As a web hosting service, phpMyAdmin is used and for the last part of the project, live messaging page for client support, Firebase is used. Further details about the project can be found in the reports shared in Github. And we also used SQL language to create and communicate with the database. For creating the interface (website) of our Database Management System and linking the Database with the interface we used PHP, HTML and CSS. Our goal was to showcase the changes that will happen to the Database when the admin manages the Database through the interface.
For more detail regarding the project please watch : https://youtu.be/icOtFXeQpRg
This course covers the fundamental topics in database management systems including ANSI/SPARC architecture, data abstraction, data independence; data definition and manipulation languages; entity-relationship and relational data models, integrity constraints, query languages like SQL, relational algebra and calculus, functional dependencies, normal forms, transaction processing recovery and concurrency control, data structure for database management systems such as indices, B-trees, hashing.