Skip to main content
SpringerLink
Log in

Teaching database systems using a practical example

  • Methodology Article
  • Published:
Earth Science Informatics Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8

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

    Google Scholar 

  • 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

    Google Scholar 

  • 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

    Article  Google Scholar 

  • Plants Database (2015) http://plants.usdgov/java/

  • Pohl K (2010) Requirements engineering. fundamentals, principles, and techniques. Springer, Berlin, pp 359–387

    Google Scholar 

  • 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

    Google Scholar 

  • 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

    Book  Google Scholar 

Download references

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

  1. Department of Geoinformatics, Palacky University, 17. listopadu 50, Olomouc, Czech Republic

    Zdena Dobesova

Authors
  1. Zdena Dobesova
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Zdena Dobesova.

Additional information

Communicated by: H. A. Babaie

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

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

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s12145-015-0241-3

Keywords

Search

Navigation