Database and Web Application for Buying Airline Tickets

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.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