Database and Web Application for Monitoring Sports Results

Tema ovog završnog rada je bio izraditi bazu podataka i web-aplikaciju za praćenje sportskih rezultata. Sustav pohranjuje podatke o sportašima, timovima, mečevima, natjecanjima te statistike sportaša i timova. Proces izrade odvijao se u dva koraka. Prvo je bilo potrebno oblikovati model entiteti-veze i relacijski model baze podataka te ju potom implementirati. Baza je ostvarena na lokalnom računalu korištenjem MS SQL Server-a (2014). Nakon toga bilo je potrebno izraditi web-aplikaciju za prikaz, unos, brisanje i izmjenu podataka iz baze korištenjem programskog jezika C#. Aplikacija je izrađena korištenjem radnog okvira ASP.NET Core (1.1.2) te radnog okvira Bootstrap (3.3.7) koji je korišten za izradu prikaza korisničkog sučelja.This thesis focuses on developing a database and web application for tracking sports results. System stores data about athletes, teams, matches, results, competitions and individual athlete statistics as well as team statistics. This process consisted of two parts. First, an entity-relationship model and relationship model of the database were designed and then it was implemented. Database was created on the local host using MS SQL Server (2014). After that web application which displays and allows modification of database data was built using programming language C#. Application was built using ASP.NET Core (1.1.2) framework and Bootstrap (3.3.7) framework which was used for designing user interface