Database theory in practice: learning from cooperative group projects

ABSTRACT

This paper describes the use of cooperative group learning concepts in support of an undergraduate database management course that emphasizes the theoretical and practical aspects of database application development. The course project is divided into three main phases, involving requirements analysis and conceptual design, relational database mapping and prototyping, and database system implementation using Microsoft Access. The project deliverables are designed so that students not only develop a database implementation, but also evaluate their design in terms of functional dependencies, normal forms, the lossless join property, and the dependency preservation property, thus establishing the need for sound database design principles. Students are required to actively participate in each phase, with students assuming different roles in each phase to allow them to experience different leadership responsibilities. As part of the grading process, students evaluate their own performance as well as the performance of others in the group. This paper describes our experience with the structure and administration of cooperative groups and provides a discussion of the lessons we have learned, including initial observations of the effectiveness of the approach.

REFERENCES

• 1: Kofi Apenyo, A database sequence: theory then practice, ACM SIGCSE Bulletin, v.22 n.4, p.5-10, Dec. 1990 [doi>10.1145/122153.122155]
• 2: S. W. Dietrich, An Educational Tool for Formal Relational Database Query Languages, Computer Science Education, vol. 4, pp. 157-184, 1993.
• 3: Ramez Elmasri , Shamkant B. Navathe, Fundamentals of database systems (2nd ed.), Benjamin-Cummings Publishing Co., Inc., Redwood City, CA, 1994
• 4: D. W. Johnson, R. T. Johnson and K. A. Smith, Active Learning: Cooperation in the College Classroom, Interaction Book Company, 1991.
• 5: Robert Leeper, A project course in database, ACM SIGCSE Bulletin, v.22 n.1, p.78-80, Feb. 1990
• 6: Amihai Motro, What to teach about databases, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.420, May 25-28, 1993, Washington, D.C., United States
• 7: D. V. Pigford, The documentation and evaluation of team-oriented database projects, ACM SIGCSE Bulletin, v.24 n.1, p.28-33, March 1992
• 8: Hossein Saiedian , Hassan Farhat, A team-oriented, project-intensive database course, ACM SIGCSE Bulletin, v.23 n.1, p.192-198, Mar. 1991

INDEX TERMS

Primary Classification:
  K. Computing Milieux
  K.3 COMPUTERS AND EDUCATION
      K.3.2 Computer and Information Science Education
          Subjects: Computer science education

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

General Terms:
Theory