prikaz prve stranice dokumenta UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3
  Download
PDF 1.69 MB
undergraduate thesis
UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3
Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2022. urn:nbn:hr:200:979731
Šarić, Marko
Josip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
Department of Software Engineering
Chair of Visual Computing

Institutional repository: Faculty of Electrical Engineering, Computer Science and Information Technology Osijek

Cite this document

Šarić, M. (2022). UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3 (Undergraduate thesis). Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek. Retrieved from https://urn.nsk.hr/urn:nbn:hr:200:979731

Šarić, Marko. "UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2022. https://urn.nsk.hr/urn:nbn:hr:200:979731

Šarić, Marko. "UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2022. https://urn.nsk.hr/urn:nbn:hr:200:979731

Šarić, M. (2022). 'UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3', Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, accessed 26 August 2024, https://urn.nsk.hr/urn:nbn:hr:200:979731

Šarić M. UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3 [Undergraduate thesis]. Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek; 2022 [cited 2024 August 26] Available at: https://urn.nsk.hr/urn:nbn:hr:200:979731

M. Šarić, "UPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3", Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, Osijek, 2022. Available at: https://urn.nsk.hr/urn:nbn:hr:200:979731

Metadata
TitleUPRAVLJANJE SQLITE3 BAZOM PODATAKA POMOĆU PYTHON 3
Title (english)Sqlite3 database management using Python3
AuthorMarko Šarić
MentorIrena Galić (mentor)
GranterJosip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
(Department of Software Engineering)
(Chair of Visual Computing)
Osijek
Defense date and country2022-09-21, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Program Engineering
Abstract
Tema ovog rada je problem pohranjivanja veće količine podataka o održavanju računalne opreme koji se vode u pojedinačnim Microsoft Excel datotekama, s obzirom da takav način pohrane podataka nije prikladan za učinkovitu pretragu, kao ni za točno i jasno vođenje evidencije održavanja opreme. Pohranjivanjem svih podataka iz pojedinačnih Microsoft Excel datoteka u jednu bazu podataka riješio bi se postojeći problem otežane pretrage i korištenja podataka. Prvenstveno je bilo potrebno omogućiti unos već postojećih podataka iz Microsoft Excel datoteka, ali i omogućiti izravan unos novih podataka u bazu. Rješenje je ostvareno upotrebom Python3 programskog jezika te modula tkinter, openpyxl i sqlite3. Python3 automatizira proces, tkinter modul pruža grafičko sučelje, openpyxl modul omogućuje interakciju sa Microsoft Excel datotekama, a sqlite3 modul omogućava sve radnje potrebne za bazu podataka. Programsko rješenje ispunilo je cilj automatizacije pohrane već postojećih podataka te je ujedno pružilo i dodatnu funkcionalnost za unos novih podataka. Uz navedeno, ostvaren je i dobar temelj za razvoj daljnjih funkcionalnosti koje će poboljšati kvalitetu ovog programskog rješenja i pružiti više mogućnosti korisnicima.
Abstract (english)
This paper focused on the problem of storing large amounts of computer maintenance data from individual Microsoft Excel files. Storing data in individual Microsoft Excel files facilitates neither an efficient data search, nor keeping an accurate and clear account of equipment maintenance. Saving all data from individual Microsoft Excel files into a single database would solve the existing problem of inefficient data search and data usage. The primary requirement was to enable import of existing data from Microsoft Excel files, but also to enable direct entry of new data into the database. This was achieved by using Python3 programming language and Python3 modules tkinter, openpyxl and sqlite3. Python3 handles the automation process, the tkinter module provides the graphical interface, the openpyxl module enables interaction with Microsoft Excel, and the sqlite3 module allows for all necessary database management. This program achieved its primary goal of automating existing data storage, it also added the functionality of inputting new data. In addition, it established the basis for development of further functionalities that will increase the program’s overall quality and provide more options for users.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:200:979731
Study programmeTitle: Undergraduate University Study Programme in Computer Engineering
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 resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2022-10-17 09:19:55