Особливості проектування фізичної моделі системи підтримки прийняття рішень фармацевтичного підприємства
Journal Title: Вісник Маріупольського державного університету.Серія: Економіка - Year 2018, Vol 8, Issue 15
Abstract
В статті розкрито сутність основних особливостей фізичної моделі системи підтримки прийняття рішень фармацевтичного підприємства та обґрунтовано вибір реляційної системи управління базами даних на основі виділених особливостей умов моделювання. The article justifies selection of a relational database management system Microsoft Access to design a physical model based on the characteristics of the simulation. The features database design for decision support of pharmaceutical enterprises identified. They are due to some specific properties of the entity attributes. The purpose of this article is to determine the characteristics of the physical model decision-making support systems for the pharmaceutical enterprise. To achieve the articles purpose were set and solved the following tasks: - to determine the parameters of the conceptual models implementation process effectiveness in the activity of pharmaceutical enterprises; - highlight features of the modeling environment the entity-relationship model into a relational database of a pharmaceutical enterprises; - to reveal the essence of the main features for the physical model decision-making support systems of the pharmaceutical enterprise. The physical design of a relational database the pharmaceutical enterprises will be carried out through the use of the software package Microsoft Access. Microsoft Access currently, is a popular and efficient relational database management system. The paper discusses its application. So, attribute «The condition of sales» can take only two values «prescription» and «without a prescription»; the attributes value «Date the wholesale supply of pharmaceutical products» must be less than the sum of the attributes values «Date of manufacture of the pharmaceutical products» and «The shelf life of the pharmaceutical product». The design of the entity «The retail supply of pharmaceutical products» involves consideration of similar characteristics of attributes «Date the retail supply of pharmaceutical products» and «The shelf life of the pharmaceutical product». The light of these characteristics will simplify the processing of big data in the pharmaceutical enterprises. So, the software package Microsoft Access ensure the implementation of the entity-relationship model decision-making support systems of the pharmaceutical enterprise with the corporate information management system. Further research aimed at implementing the physical database model of a pharmaceutical enterprise.
Authors and Affiliations
T. V. Shabelnyk
Keywords
Related Articles
- EP ID EP524265
- DOI -
- Views 73
- Downloads 0
Модель оптимального экономического роста при гарантированных уровнях производственного накопления и непроизводственного потребления
Рассматривается математическая модель динамики национального дохода с учетом влияния научно-технического прогресса и гарантированными уровнями производственного накопления и непроизводственного потребления. Даная модел...
Интернет технологии формирования политической культуры
В статье рассматривается интернет как эффективный канал политической коммуникации, анализируются различные аспекты влияния интернет-технологий на формирование политической культуры.
FINANCIAL ISSUES OF REGIONAL DEVELOPMENT AND INTERREGIONAL COOPERATION OF UKRAINIAN REGIONS
The paper considers the problems of financial support for regional development and interregional cooperation, among which there are low level of municipal securities emission and insufficient number of financial infrastr...
CURRENCY REGULATION ROLE IN TERMS OF THE GLOBAL FINANCIAL ENVIRONMENT DESTABILIZATION
This paper examines the modern approaches to defining the essence of «currency regulation» category. The author's definition of the essence of this economic category is provided. The modern instruments for currency regul...
Improvement of migration policy of Ukraine in the context of strengthening of interregional cooperation
The article discusses the advantages and disadvantages of Ukraine's migration policy. Have proved the necessity to improve it and suggested an appropriate mechanism in view of the need to intensify inter-regional coopera...