Creation of the database prototype

Donatas Daugirdas; Justinas Zatorskis

doi:10.56131/tmt.2023.2.1.112

Authors

Donatas Daugirdas Šiaulių valstybinė kolegija / Šiauliai State Higher Education Institution, Lithuania; Lecturer of the Department of Informatics Science
Justinas Zatorskis Šiaulių valstybinė kolegija / Šiauliai State Higher Education Institution, Lithuania; Student of the Software engineering study program

DOI:

https://doi.org/10.56131/tmt.2023.2.1.112

Abstract

The article analyzes the creation of a database prototype commissioned by the company. A similarity analysis compared 3 similar systems. When comparing the possible development technologies, the requirements for the system being developed were taken into account, and a working prototype was created in the operating system used by the company. Designed diagrams illustrating the principles of system operation, user use cases and database structure. Functionality for system use was defined. Programmed application, system prototype "STRWarehouseApp" which stores and processes data in MySQL database. System prototype testing was performed throughout the programming process.

Keywords: database, prototype, warehouse inventory management system, design.