Student schedule web application with Oracle database support

S pomakom tehnologije nastaje povećanje stupnja digitaliziranosti našeg svakodnevnog života. Cilj ovog rada jest razvoj web aplikacije koja svakom pojedinačnom studentu prikazuje raspored s njegovim nastavnim grupama i nudi mogućnost izvoza u druge aplikacije i platforme. Aplikacija je izrađena u Oracle APEX razvojnom okviru i platformi za razvoj aplikacija s malom količinom programskog koda. Prije toga je demonstriran postupak dizajniranja ER i relacijskog modela baze podataka kao i postupak dizajniranja i pisanja pogleda unutar baze podataka. Osim toga objašnjene su i pozadinske tehnologije i standardi na kojima su temeljene značajke aplikacije i pozadinskih servisa za dohvat i posluživanje podataka korisnicima. Na kraju je demonstriran rad responzivne web aplikacije za osobna računala i pametne telefone koja studentima omogućuje izračun i prikaz slobodnog vremena s njihovim kolegama, dodavanje osobnih događaja vezanih uz nastavu i studiranje u kalendar kao i prikaz i izvoz njihovih rasporeda u druge aplikacije.With the shift in technology comes an increase in the degree of digitization of our daily lives. The aim of this paper is to develop a web application that shows each individual student a schedule with their teaching groups and offers the possibility of exporting the timetable to other applications and platforms. The application is built in the Oracle APEX framework and “low-code” application development platform. Prior to that, the process of designing an ER and a relational database model, as well as the process of designing and writing views within a database were demonstrated. In addition, the background technologies, and standards on which the features of the application and background services for retrieving and serving data to users are based on are explained. Finally, a responsive web application for personal computers and smartphones was demonstrated that allows students to calculate and display free time with their colleagues, add personal study-related events to the calendar, as well as display and export their timetables to other applications