BazEkon - The Main Library of the Cracow University of Economics

BazEkon home page

Main menu

Author
Szczęśniak Bartosz (Silesian University of Technology, Poland)
Title
Microtools Based on the Relational Data Model - Conformity Between Foreign and Primary Keys
Source
Multidisciplinary Aspects of Production Engineering, 2018, vol. 1, s. 491-497, rys., tab., bibliogr. 20 poz.
Keyword
Arkusze kalkulacyjne, Bazy danych, Proces informacyjny, Procesy biznesowe
Spreadsheets, Databases, Information process, Business processes
Note
streszcz., summ.
Abstract
Tools which support and automate the execution of information processes may be created in a spreadsheet by following the author's signature concept of "Microtools Based on the Relational Data Model". While developing them, one must apply adequate solutions enabling representation of identified entities and ensuring data integrity as well as acquisition of the reports and collations assumed to be generated. This article addresses the problem of conformity between values of foreign keys in child entities and values of primary keys in parent entities. Four cases of relationships between a parent entity and a child entity have been discussed. One of the criteria that differentiates between these cases is the occurrence of a simple key or a composite key. Another applicable criterion is the sequence in which data are entered using the tool. With regard to all the identified cases, solutions that support data integrity have been presented and discussed. In accordance with the concept in question, the solutions proposed in the paper make use of standard spreadsheet features and components, without involving any additional code created in any programming language. (original abstract)
Full text
Show
Bibliography
Show
  1. Carlberg, C. (2009). Microsoft Excel 2007 PL. Analizy biznesowe. Rozwiązania w biznesie. Wydanie III. Gliwice: Helion.
  2. Gajdzik, B.,Sitko, J. (2014). An analysis of the causes of complaints about steel sheets in metallurgical product quality management systems. Metalurgija, 53(1), pp. 135-138.
  3. Jackson, M., Staunton, M. (2013). Zaawansowane modele finansowe z wykorzystaniem Excela i VBA. Gliwice: Helion.
  4. Knight, G.(2006). Analyzing Business Data with Excel. Sebastopol: O'Reilly Media
  5. Loska, A.,(2012). Remarks about modelling of maintenance processes with the use of scenario techniques. Eksploatacja i Niezawodnosc - Maintenance and Reliability,14(2), pp. 92-98.
  6. Midor, K., Kučera, M. (2018). Improving the Service with the Servqual Method. Management Systems in Production Engineering, 26(1), pp. 60-65.
  7. Oleński, J. (2001). Ekonomika informacji. Podstawy. Warszawa: PWE.
  8. Oleński, J. (2002). Ekonomika informacji. Metody. Warszawa: PWE.
  9. Restecka, M., Wolniak, R. (2016). IT systems in aid of welding processes quality management in the automotive industry. Archives of Metallurgy and Materials, 61(4), pp. 1785-1792
  10. Sroka, J., Panasiuk, A., Stencel, K., Tyszkiewicz, J. (2015). Translating Relational Queries into Spreadsheets. IEEE Transactions On Knowledge and Data Engineering, 27(8), pp. 2291-2303.
  11. Szczęśniak, B. (2010). Arkusz kalkulacyjny w doskonaleniu procesu układania planu zajęć w szkole specjalnej. In: R. Knosala, ed., Komputerowo zintegrowane zarządzanie, Opole: Oficyna Wydawnicza Polskiego Towarzystwa Zarządzania Produkcją, Opole. 2, pp. 222-233.
  12. Szczęśniak, B. (2010). Zastosowanie arkusza kalkulacyjnego do wspomagania metody ABC. ZeszytyvNaukowe Politechniki Śląskiej, seria Organizacja i Zarządzanie, 50, pp. 23-33.
  13. Szczęśniak, B. (2016). Mikronarzędzia bazujące na relacyjnym modelu danych a rozwój specjalizacji inteligentnych. Systemy Wspomagania w Inżynierii Produkcji -Metody i Narzędzia Inżynierii Produkcji dla Rozwoju Inteligentnych Specjalizacji, 4(16), pp.121-131.
  14. Szczęśniak, B. (2017). Microtools Based on the Relational Data Model - representation of entities in a spreadsheet. In: 17th International Multidisciplinary Scientific GeoConference SGEM 2017. Albena, 17(21), pp. 447-454.
  15. Szczęśniak, B., Molenda, M. (2013). Spreadsheet application supporting the x-r control chart. In: 22th Conference Modern Mathematical Methods in Engineering (3mi). Horní Lomná, pp. 128-134.
  16. Tyszkiewicz, J. (2010). Spreadsheet As a Relational Database Engine, In: ACM SIGMOD International Conference on Management of data, Indianapolis, pp.195-206.
  17. Wilczewski, S., Wrzód, M. (2008). Excel 2007 w firmie. Controlling, finanse i nie tylko. Gliwice: Helion.
  18. Winston, W. L. (2011). Microsoft Excel 2010. Data Analysis and Business Modeling. Third Edition. Washington: Microsoft Press.
  19. Zasadzień, M., Midor, K. (2015). Innovative application of quality management tools in a hard coal mine. In: 15th International Multidisciplinary Scientific GeoConference SGEM 2015. Albena, 1(3), pp. 415-422.
  20. Zasadzień, M., Žarnovský, J. (2018). Improvement of Selected Logistics Processes Using Quality Engineering Tools. Management Systems in Production Engineering, 26(1), pp. 55-59.
Cited by
Show
ISSN
2545-2827
Language
eng
URI / DOI
http://dx.doi.org/10.2478/mape-2018-0062
Share on Facebook Share on Twitter Share on Google+ Share on Pinterest Share on LinkedIn Wyślij znajomemu