Abstract
This article describes how practical lectures can be innovated by the experience of a practical case study. The design and implementation of the geographical information system BotanGIS brought several innovations to the study branch Geoinformatics at the Faculty of Science of Palacky University in Olomouc. This article deals mainly with introducing a new practical example into the course Database Systems. This new theme explains the design and inner structure of the relational database BotanGIS. The valuable contribution lies in the way a real database example from practice is explained to the students in the process of education. The instruction started with a visit to the botanical garden and the collection greenhouses. Subsequently, students worked at a computer laboratory, trying to find some information about plants by various queries in the botanical portal BotanGIS. Finally, a detailed model of the relational database was explained. The teacher’s experience enriched the students’ knowledge in the field of the conceptual database design.
Similar content being viewed by others
References
ANGIOSPERM PHYLOGENY WEBSITE, v.14, http://www.mobot.org/MOBOT/research/APweb/
BotanGIS (2014) http://botangis.upol.cz/
Coronel C, Morris S, Rob P (2012) Database systems, design, implementation, & management, 10th ed., Cengage Learning, 720p
Dancak M, Šupová H, Škardová P, Dobesova Z, Vávra A (2013) Zajímavé rostliny subtropického skleníku Výstaviště Flora Olomouc. (Interesting Plants of the Subtropical Greenhouse of Fairgrounds Flora Olomouc). Palacky University, Olomouc, 48p
Dobesova Z (2004) Databázové systémy v GIS. (Database systems in GIS). Palacký University Olomouc, Olomouc, 76p
Dobesova Z (2012) Geographic information systems for botanical garden - steps of design and realization, in Proc. SGEM 2012 12th International Multidisciplinary Scientific GeoConference, Vol. III, STEF92 Technology Ltd., Sofia, Bulgaria, pp 377–384
Dobesova Z, Vavra A, Nétek R (2013a) Cartographic aspects of creation of plans for botanical garden and conservatories. In: Proc. SGEM 2013 13th International Multidisciplinary Scientific GeoConference, Vol. I, STEF92 Technology Ltd. Sofia, Bulgaria, pp 653–660
Dobesova Z, Burian J, Miřijovský J, Vávra A, Nétek R, Popelka S (2013b) Tvorba geografického informačního systému malého území. (Creation of the Geographical Information System for a Small Area), Palacky University, Olomouc, 106p
Hernandez MJ (2003) Database design for mere mortals: a hands-on guide to relational database design, 2nd edn. Addison-Wesley Professional, Boston
Lebeda A, Křístková E, Dobesova Z, Cigánek D (2013) Průvodce Botanickou zahradou. (Guide of the Botanical Garden), Palacky University, Olomouc, 25p
Möllerová J (2012) Homo botanicus Tachtadžjan, Armen Leonovič, http://botany.cz/cs/tachtadzjan/
Moss K (2010) DataBase teaching tools, IEEE EDUCON Education Engineering - The Future of Global Learning Engineering Education, Madrid, Spain, pp. 1881–1890
Němcová Z, Pechanec V, Vávra A, Voženílek V (2011) Realization of E-learning courses for the education of climate. New Educ Rev 24(2):214–230
Netek R, Dobesova Z, Vavra A (2014) Innovation of botany education by cloud-based geoinformatics system. In: Wang Q. (ed) Innovative use of online platforms for learning support and management, Int. J. Information Technology and Management, Vol. 13, No. 1, Inderscience Enterprises Ltd., pp 15–31
Pechanec V, Vávra A (2013) Education portal on climate change with web GIS client. J Cases Inf Technol 15(1):51–68
Plants Database (2015) http://plants.usdgov/java/
Pohl K (2010) Requirements engineering. fundamentals, principles, and techniques. Springer, Berlin, pp 359–387
Portal of the Czech Flora (Portál české flóry) (2013) http://flora.upol.cz/
Riordan RM (2005) Designing effective database systems. Addison-Wesley Professional, Upper Saddle River, 384 p
Seidewitz E (2003) What Model Means. IEEE Software, Vol. 20, No. 5, IEEE Press, Los Alamitos, pp 26–32
Tropicos (2015) http://www.tropicos.org/home.aspx
Yeung AKW, Hall GB (2007) Spatial database systems, design, implementation and project management. Springer, Dordrecht, 553 p
Acknowledgments
The design and implementation of the botanical information system BotanGIS were supported by the project CZ.1.07/2.3.00/20.0170 and CZ.1.07/2.2.00/15.02661.
Author information
Authors and Affiliations
Corresponding author
Additional information
Communicated by: H. A. Babaie
Rights and permissions
About this article
Cite this article
Dobesova, Z. Teaching database systems using a practical example. Earth Sci Inform 9, 215–224 (2016). https://doi.org/10.1007/s12145-015-0241-3
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s12145-015-0241-3