Baza podataka i web-aplikacija za kupnju zrakoplovnih karata

undergraduate thesis

• Title (english): Database and Web Application for Buying Airline Tickets
• Author: Filip Pleša
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Mirta Baranović (član povjerenstva)
• Committee member: Mario Brčić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2019-07-12, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Tema ovog završnog rada je izrada baze podataka i web-aplikacije za rezervaciju i kupnju zrakoplovnih karata. Sustav pohranjuje podatke o letovima i nudi korisnicima opciju rezerviranja sjedala. Sustav pamti rezervacije te koja su sjedala slobodna i zauzeta i sukladno ažurira tome bazu podataka. Administratori imaju mogućnost unošenja podataka o novim letovima.

Programski sustav sastoji se od baze podataka i web-aplikacije. Razvijen je model baze podataka korištenjem ER i relacijskog modela. Baza podataka je implementirana korištenjem sustava za upravljanje bazom podataka PostgreSQL. Korištenjem programskog jezika Java i razvojnog okvira Spring Boot izrađena je web-aplikacija koja pretražuje, unosi i ažurira podatke u bazi.

Korisničko sučelje oblikovano je korištenjem razvojnog okvira Bootstrap i tehnologijama HTML5, CSS, JavaScript i jQuery.

Abstract (english)

This Bachelor thesis describes the process of developing web application for reservation and purchasing airline tickets. The system stores data about flights and offers users a way to book airline tickets. It stores reservations and updates the availability status of seats on a flight in the database. System administrator has the ability to input data about new flights creating them in the database.

The software system consists of a database and a web application. Database was designed by creating entity-relationship and relational database models. It was then implemented using PostgreSQL. The web application which interacts with the user and updates data in the database accordingly was built using Java and Spring Boot framework.

The user interface was designed using the Bootstrap framework and HTML5, CSS, JavaScript and jQuery.

• Keywords: zrakoplovne karte; rezervacije; baza podataka; web-aplikacija; PostgreSQL; Java; Spring; Bootstrap; HTML5; CSS
• Keywords (english): airline tickets; reservations; database; web application; PostgreSQL; Java; Spring; Bootstrap; HTML5; CSS
• Language: croatian
• URN:NBN: urn:nbn:hr:168:796442
• 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: 2020-01-07 21:24:12