Baza podataka i web-aplikacija za organiziranje kvizova

undergraduate thesis

• Title (english): Database and web application for organizing quizzes
• Author: Marko Car
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Boris Milašinović (član povjerenstva)
• Committee member: Melita Fertalj (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2022-07-04, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Svrha i tema ovog završnog rada je izrada programskog sustava za organiziranje kvizova. Sustav služi organiziranju kvizaških događaja i pohrani podataka o kvizovima, pitanjima, odgovorima i nagradi. Također omogućuje sudjelovanje u nekom kvizu i ostavljanje dojmova.
Programski sustav sastoji se od dvije komponente: baze podataka i pripadne web aplikacije koja služi za rukovanje bazom. Baza podataka implementirana je koristeći sustav za upravljanje bazom podataka MySQL, a web aplikacija izrađena je pomoću programskog jezika PHP i njemu pripadajućem radnom okviru Symfony, za vizualni prikaz aplikacije korištena je Twig biblioteka.
Rad sadrži opis ER modela, relacijski model, upute za implementaciju MySQL baze podataka, opis aplikacije i upute za njezino korištenje.

Abstract (english)

The purpose and focus of this final document is to create a software system for organisation of quizzes. The system is used to organize quizzes and store information on quizzes, questions, answers, prizes. It enables you to participate in a quiz and leave impressions.
The software system consists of two components: a database and a corresponding web application that serves to manage the database. The database was implemented using the MySQL database management system and web application was developed using the PHP programming language and its associated Symfony framework, to visually display the application Twig library was used.
The paper contains a description of the ER model, a relational model, instructions for setting up a MySQL database, a description of application and instructions for using it.

• Keywords: backend; frontend; php; symfony; twig; html; css; mysql; mvc; swagger; dbeaver; phpstorm; doctrine
• Keywords (english): backend; frontend; php; symfony; twig; html; css; mysql; mvc; swagger; dbeaver; phpstorm; doctrine
• Language: croatian
• URN:NBN: urn:nbn:hr:168:187594
• Study programme: Title: Computing; Study programme type: university; Study level: undergraduate; Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2023-01-15 09:53:12