1. Creation of a data model of a selected agenda of the company's economic information system
- Author
-
SOUKUP, Josef
- Subjects
byznys proces ,normalizace databáze ,BPMN ,trigger ,use case ,data model ,business process ,datový model ,information system ,procedure ,SQL ,spouštěč ,ERP ,procedura ,informační systém ,database normalization ,případ užití - Abstract
The objective of this thesis is to analyze a selected business agenda and create a conceptual and physical data model of an information system for this agenda on a selected database system. The first part of the thesis are focused on description of information systems and their classification. Data modeling features and requirements are characterized in this part. Following part presents the selection of a modelling tool for creating a data model based on a multi-criteria evaluation. The conceptual schema is modeled using the selected tool. It captures the necessary entities and their attributes to meet the defined requirements. The purpose of creating data model is capture the agenda of warehouse management of small stonemasonry company in South Bohemia region. Each chapter is focused on different part of creating database such as the conceptual, logical and physical levels. To test the created physical model SQL code is generated and uploaded to the web platform bit.io supporting PostgreSQL.
- Published
- 2023