Information system model for pharmacy

Ovim radom prikazano je oblikovanje informacijskog sustava na primjeru poslovanja ljekarne. Prije pristupa samom radu bilo je potrebno razumjeti kako poslovni sustav funkcionira. Na početku rada opisan je sam informacijski sustav i njegove najbitnije stavke. U informacijskom sustavu za ljekarnu opisani su i analizirani njegovi glavni procesi, napravljen je DTP dijagram, ER model te relacijski model (RM) podataka. Provjereno je zadovoljava li model baze podataka pravila prve tri normalne forme. Na kraju su prikazani algoritmi za dobivanje najvažnijih informacija iz oblikovane baze podataka.This work shows the design of the information system on the example of the business of a pharmacy. Before starting the actual work, it was necessary to understand how the business system works. At the beginning of the paper, the information system itself is described and its most important items are described too. In the information system for a pharmacy, its main processes were described and analyzed, a DTP diagram, an ER model and a relational dana model (RM) were created. It was checked whether the database model satisfies the rules of the first three normal forms. At the end, the algorithms for obtaining the most important information from the designed database are presented