A virtual learning environment for entity relationship modelling

ABSTRACT

Entity Relationship Modelling (ERM) is a fundamental skill in database design. Though ERM concepts are simple, the modelling process itself is a complex activity. Novice ER modellers make systematic errors in their models. Current tool-based support for learning ER modelling is limited, since it concentrates on notation at the expense of methodology, and provides little or no feedback to the learner about the quality of her constructed models. A text-based virtual learning environment, based on the Multi-User Dimension paradigm, is described, in which learners undertake ER modelling tasks by interacting with objects in a virtual world. This learning environment concentrates on the methodology of ER modelling rather than its notation, and provides immediate feedback to a learner about the quality of her models. Preliminary results suggest that this learning environment is both easy to use and effective.

REFERENCES

• 1: Acker, S.R., Space, collaboration, and the credible city: Academic work in the virtual university, ,Tour. Computer- Mediated Communication, 1, 1, (1995).
• 2: Judith D. Ahrens , Il-Yeol Song, EER modeling aids for novice database designers, Proceedings of the 1991 Information Resources Management Association international conference on Managing information technology in a global society, p.99-114, August 1991, Memphis, Tennessee, United States
• 3: D. Batra , J. A. Hoffler , R. P. Bostrom, Comparing representations with relational and EER models, Communications of the ACM, v.33 n.2, p.126-139, Feb. 1990 [doi>10.1145/75577.75579]
• 4: Dinesh Batra , Joseph G. Davis, Conceptual data modelling in database design: similarities and differences between expert and novice designers, International Journal of Man-Machine Studies, v.37 n.1, p.83-101, July 1992 [doi>10.1016/0020-7373(92)90092-Y]
• 5: Batra, D. And Antony, S.R., Novice Errors in Conceptual Database Design, European Jour. Information Systems, 3, 1, (Jan, 1994)57-69
• 6: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 7: Chen, P.P., English Sentence Structure and Entity Relationship Diagrams, Information Science, (May 1983), 221-243.
• 8: Fanderclai, T.L., MUDs in Education: New' Environments, New Pedagogues, CMC Magazine, 2, 1 (Jan 1995).
• 9: Hannafin, M. J., Emerging technologies, ISD, and learning environments: Critical perspectives, Educational Technology Research and Development, 40, 1, (1992), 49- 63.
• 10: H0ffer, J., An Empirical Investigation into Individual Differences in Database Models, Proc. 3rdInt. Conf. Information Systems, (1982), 1"53-167.
• 11: Hoggarth, G.R., and Lockyer, M.A., Systems development methods guidance and CASE: integration between CASE and CAL~ Software Engineering Journal, (May 1996), 141-147
• 12: John K. Ousterhout, Tcl and the Tk toolkit, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1994
• 13: Reeves, T., Evaluating What Really Matters in Computer-Based Education, at http://www.oltc.edu.au/cp/refs/reeves.html
• 14: Veda C. Storey , Robert C. Goldstein, A methodology for creating user views in database design, ACM Transactions on Database Systems (TODS), v.13 n.3, p.305-338, Sept. 1988 [doi>10.1145/44498.45064]
• 15: Robert C. Goldstein , Veda C. Storey, Some Findings on the Intuitivness of Entity-Relationship Constructs, Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying, p.9-23, October 18-20, 1989
• 16: Toby J. Teorey , Dongqing Yang , James P. Fry, A logical design methodology for relational databases using the extended entity-relationship model, ACM Computing Surveys (CSUR), v.18 n.2, p.197-222, June 1986 [doi>10.1145/7474.7475]
• 17: NASA Software Technology Branch. CLIPS Reference Manual, 1997

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

  I. Computing Methodologies
  I.6 SIMULATION AND MODELING

  K. Computing Milieux
  K.3 COMPUTERS AND EDUCATION

General Terms:
Design, Human Factors, Management, Performance, Theory