Baza podataka kao potpora web aplikaciji

master's thesis

• Title (english): Database support for web appliacation
• Author: Ena Glavač
• Mentor: Katarina Ćurko (mentor); MBZ: 172003
• Committee member: Ivan Strugar (predsjednik povjerenstva)
• Committee member: Božidar Jaković (član povjerenstva)
• Committee member: Katarina Ćurko (član povjerenstva)
• Granter: University of Zagreb; Faculty of Economics and Business; (Department of Informatics); Zagreb
• Defense date and country: 2019-09-18, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing; Information Systems

Abstract

U današnjem svijetu zbog raširenosti Interneta i digitalizacije poslovanja izrada ili korištenje web aplikacija, bilo u privatne ili u poslovne svrhe je neizbježna. Neovisno o specifičnoj namjeni web aplikacije sigurno je da se njeni podaci, bilo da su generirani od strane korisnika ili kreatora aplikacije negdje moraju spremiti što čini baze podataka nezaobilaznim dijelom u procesu razvoja web aplikacije. Unatoč velikom razvoju tehnologija i pojavi novih vrsta baza podataka, relacijske baze podataka još uvijek su vrlo aktualne i imaju široku primjenu. U ovom radu dani su teorijski temelji relacijske baze podataka i web aplikacije, a u praktičnom dijelu prikazani su svi koraci u procesu izrade relacijske baze podataka za specifičnu web aplikaciju. Analizom funkcionalne specifikacije prikazan je konceptualni model baze i ER model dok je kroz logički model prikazan relacijski model koji je implementiran u Miscrosoft SQL Serveru. Logika web aplikacije implementirana je preko u SQL-u ispisanih procedura i okidača.

Abstract (english)

In a world today because of wide range of Internet access and digital transformation, development or usage of web application, be it for private or business purposes is inevitable. Not taking into account the specific purpose of web application it is a given that data, generated from users or application developers, needs to be stored somewhere. For that reason databases are one of the integral parts in web application development process. Despite emergence of new technologies and new types of databases, relational databases are still very current and widely used. This thesis describes the theoretical foundations of the relational databases, while in the practical part all the steps in the process of creating a relational database for specific web application are presented systematically. The analysis of functional specification shows the conceptual model of the database and the ER model, while the logical model shows the relational model, later implemented in Microsoft SQL Server. Web application logic is implemented via SQL written procedures and triggers.

• Keywords: Baze podataka; relacijski model; ER model; SQL; web aplikacija; analiza; specifikacija; SQL server
• Keywords (english): Databases; relational model; ER model; SQL; web application; analysis; specification; SQL server
• Language: croatian
• URN:NBN: urn:nbn:hr:148:247206
• Study programme: Title: Business Economics; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra ekonomije (magistar/magistra ekonomije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Access restricted to students and staff of home institution
• Created on: 2019-09-18 19:30:49