Advanced database concepts for undergraduates: experience with teaching a second course

ABSTRACT

This paper describes the development of a second database course for undergraduates, preparing students for the advanced database concepts they will experience in industry. Assuming an introductory course on relational database systems as a prerequisite, the topics addressed in the course include object-oriented data modeling, object-oriented database systems, object-relational database systems, Web access to databases, and professionalism and ethics. We present our experience with teaching the course, elaborating on the topics and assignments. We also present feedback from students and industry partners as well as our own assessment of future course refinements.

REFERENCES

• 1: R. G. G. Cattell , Douglas K. Barry , Mark Berler , Jeff Eastman , David Jordan , Craig Russell , Olaf Schadow , Torsten Stanienda , Fernando Velez, The object data standard: ODMG 3.0, Morgan Kaufmann Publishers Inc., San Francisco, CA, 2000
• 2: Harvey M. Deitel , Paul J. Deitel , T. R. Nieto, Internet and World Wide Web How to Program, Prentice Hall PTR, Upper Saddle River, NJ, 2001
• 3: Suzanne W. Dietrich , Dan Suceava , Chakrapani Cherukuri , Susan D. Urban, A reusable graphical user interface for manipulating object-oriented databases using Java and XML, Proceedings of the thirty-second SIGCSE technical symposium on Computer Science Education, p.362-366, February 2001, Charlotte, North Carolina, United States
• 4: Dietrich, S. W. and Urban, S. D. A Cooperative Learning Approach to Database Group Projects: Integrating Theory and Practice. IEEE Transactions on Education, (Nov 1998), CD-ROM Directory 06, 11 p.
• 5: Ramez Elmasri , Shamkant B. Navathe, Fundamentals of database systems (2nd ed.), Benjamin-Cummings Publishing Co., Inc., Redwood City, CA, 1994
• 6: Jason Hunter , William Crawford, Java servlet programming, O'Reilly & Associates, Inc., Sebastopol, CA, 1998
• 7: Objectivity/DB Version 5.1: Database Development, Objectivity Inc., 1999.
• 8: Oracle Corporation, Oracle 8 Reference Manual, Release 8.0, 1999.
• 9: Raghu Ramakrishnan, Database management systems, McGraw-Hill, Inc., New York, NY, 1997
• 10: James Rumbaugh , Ivar Jacobson , Grady Booch, The Unified Modeling Language reference manual, Addison-Wesley Longman Ltd., Essex, UK, 1998
• 11: Susan D. Urban , Suzanne W. Dietrich, Integrating the practical use of a database product into a theoretical curriculum, Proceedings of the twenty-eighth SIGCSE technical symposium on Computer science education, p.121-125, February 27-March 01, 1997, San Jose, California, United States
• 12: Urban, S. D., Dietrich, S. W., and Tapia, P., Mapping UML Diagrams to Object-Relational Schemas in Oracle 8, Succeeding with Object Databases: A Practical Look at Today's Implementations with Java and XML, J. Wiley Publishers, A. Chaudri and R. Zicari (editors), 2000.

INDEX TERMS

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

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

  K. Computing Milieux
  K.3 COMPUTERS AND EDUCATION
      K.3.2 Computer and Information Science Education
          Subjects: Curriculum

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