Skip to main content
SpringerLink
Log in

Using Design Patterns to Teach Conceptual Entity Relationship (ER) Data Modelling

  • Conference paper
  • First Online:
Innovative Technologies and Learning (ICITL 2021)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 13117))

Included in the following conference series:

  • 1735 Accesses

Abstract

Relational databases are core to the development of information systems. Designing and presenting a quality conceptual Entity Relationship (ER) data schema to model the entities, attributes and relationships in such a database is equally important. Context and assumptions play an important role in the construction of these schemas. University students have limited real-world experience and typically struggle with the construction of database schemas. Case studies are used to provide students with functional details and context. Patterns are considered useful to transfer best practices and expert knowledge from experts to novice users. This paper proposes the use of patterns to teach ER data modelling to second year Systems Analysis and Design (SAD) students. An example ER pattern for a Point-of-Sales (POS) system is proposed with one possible context adjustment. Assumptions, functional requirements and business rules form part of the proposed pattern to explain the different contexts in which the pattern could be applied as well as the effect that these context adjustments will have on the ER data model. Guidelines are given to assist lectures with using the pattern to teach their students conceptual ER data modelling.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 99.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 129.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Connoly, T.M., Begg, C.E.: A constructivist-based approach to teaching database analysis and design. J. Inf. Syst. Educ. 17, 43 (2006)

    Google Scholar 

  2. Smuts, H., Hattingh, M.J.: Towards a knowledge conversion model enabling programme design in higher education for shaping industry-ready graduates. In: Kabanda, S., Suleman, H., Gruner, S. (eds.) SACLA 2018. CCIS, vol. 963, pp. 124–139. Springer, Cham (2019). https://doi.org/10.1007/978-3-030-05813-5_9

    Chapter  Google Scholar 

  3. ABET: ABET Accreditation (2021). https://www.abet.org/. Accessed 29 July 2021

  4. Chen, P.P.-S.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. 1, 9–36 (1976). https://doi.org/10.1145/320434.320440

    Article  Google Scholar 

  5. Eid, I.: A learning system for entity relationship modeling. In: PACIS 2012 Proceedings (2012)

    Google Scholar 

  6. Hingorani, K., Gittens, D., Edwards, N.: Reinforcing database concepts using entity relationship diagrams (ERD) and normalization together for designing robust databases. IIS 18, 202–209 (2017). https://doi.org/10.48009/1_iis_2017_148-155

    Article  Google Scholar 

  7. Yang, L., Cao, L.: The effect of MySQL workbench in Teaching Entity-Relationship Diagram (ERD) to relational schema mapping. Int. J. Mod. Educ. Comput. Sci. 8(7), 1–12 (2016). https://doi.org/10.5815/ijmecs.2016.07.01

    Article  MathSciNet  Google Scholar 

  8. Hussain, T.: Teaching entity-relationship models effectively. In: 2016 International Conference on Computational Science and Computational Intelligence (CSCI), pp 264–269 (2016)

    Google Scholar 

  9. Kolfschoten, G.L., de Vreede, G.-J.: A design approach for collaboration processes: a multimethod design science study in collaboration engineering. J. Manage. Inf. Syst. 26, 225–256 (2009)

    Article  Google Scholar 

  10. Douglas, L., Pamela, S., Katie, D., Jim, B.: Deconstructing the Education-Industrial Complex in the Digital Age. IGI Global (2017)

    Google Scholar 

  11. Grimshaw, D.J., Mott, P.L., Roberts, S.A.: The role of context in decision making: some implications for database design. Eur. J. Inf. Syst. 6(2), 122–128 (1997)

    Article  Google Scholar 

  12. Rosatelli, M.C., Self, J.: A collaborative case study system for distance learning. Int. J. Artif. Intell. Educ. 14, 97–125 (2004)

    Google Scholar 

  13. Winters, N., Mor, Y.: Dealing with abstraction: case study generalisation as a method for eliciting design patterns. Comput. Hum. Behav. 25, 1079–1088 (2009)

    Article  Google Scholar 

  14. Eckstein, J.: Pedagogical patterns: capturing best practices in teaching object technology. Softw. Focus 2, 9–12 (2001). https://doi.org/10.1002/swf.19

    Article  Google Scholar 

  15. Alexander, C., Ishikawa, S., Silverstein, M., et al.: A Pattern Language: Towns, Buildings, Construction. Oxford University Press, New York (1977)

    Google Scholar 

  16. Gamma, E., Helm, R., Johnson, R., et al.: Design Patterns: Elements of Reusable Object-Oriented Software, 1st edn. Addison-Wesley Professional, Reading (1994)

    Google Scholar 

  17. Coplien, J.: Idioms and patterns as architectural literature. IEEE Softw. 14, 36–42 (1997)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Pretoria, Private Bag X20, Hatfield, 0028, UK

    Lizette Weilbach, Marié Hattingh & Komla Pillay

Authors
  1. Lizette Weilbach
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Marié Hattingh
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Komla Pillay
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Lizette Weilbach .

Editor information

Editors and Affiliations

  1. National Cheng Kung University, Tainan, Taiwan

    Yueh-Min Huang

  2. National Cheng Kung University, Tainan, Taiwan

    Chin-Feng Lai

  3. University of Trás-os-Montes and Alto Douro, Villa Real, Portugal

    Tânia Rocha

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Weilbach, L., Hattingh, M., Pillay, K. (2021). Using Design Patterns to Teach Conceptual Entity Relationship (ER) Data Modelling. In: Huang, YM., Lai, CF., Rocha, T. (eds) Innovative Technologies and Learning. ICITL 2021. Lecture Notes in Computer Science(), vol 13117. Springer, Cham. https://doi.org/10.1007/978-3-030-91540-7_25

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-91540-7_25

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-91539-1

  • Online ISBN: 978-3-030-91540-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation