Asee peer logo

Students’ Experiences From Implementing A Single Problem In Relational, Object Relational, And Object Oriented Database Systems

Download Paper |


2009 Annual Conference & Exposition


Austin, Texas

Publication Date

June 14, 2009

Start Date

June 14, 2009

End Date

June 17, 2009



Conference Session

Curricular Issues in Computer-Oriented Programs

Tagged Division

Information Systems

Page Count


Page Numbers

14.1090.1 - 14.1090.6



Permanent URL

Download Count


Request a correction

Paper Authors

author page

Reza Sanati-Mehrizy Utah Valley State College

author page

Floyd Wilkes Utah Valley University

author page

Afsaneh Minaie Utah Valley University

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Student Experiences from Implementing a Single Problem in Relational, Object-Relational and Object-Oriented Database System


In a previous paper2, the authors presented an abbreviated example of implementing a common problem in the relational, object-relational and object-oriented database models. The hypothesis was that understanding these latter models would be easier for students if they saw the same database example presented in all these three models. As a test of this premise, one of the authors gave students in a database class the assignment of implementing a database problem in the three models. Students who participated were asked to report their experiences from completing the assignment. The results obtained from the students are evaluated and reported in this paper.

Keywords Database Design, Relational databases, Object-Relational databases, Object-Oriented databases.

1. Introduction

In a previous paper1, the authors discussed a perceived difficulty that students have learning the features, capabilities, and uses of the three major database models: relational, object-relational and object-oriented. It was hypothesized that in part, this difficulty comes from the fact that in most database textbooks, these database models are presented in such a way that it is difficult to compare and contrast the features and possible uses of each model with the other two. In another paper2, the authors presented an example of the implementing a common problem in the three database models. One of the authors then used this concept in a database class, asking the students to select a problem and implement it the relational, object-relational and object-oriented database models. At the conclusion of the class the students were surveyed to gather information regarding their experiences in this process. In this paper, we present the reactions of the students who participated in this process.

2. Teams of Two

As part of a junior level computer science database theory class (CS 3520) students were organize into teams of two. Each team selected a project from a list of projects provided by the instructor (see Figure 1). Team 1: Employee Database Team 2. Bank Database Team 3. University Database Team 4. Patient Database Team 5. Recipe Database

Figure 1. Projects Selected

Sanati-Mehrizy, R., & Wilkes, F., & Minaie, A. (2009, June), Students’ Experiences From Implementing A Single Problem In Relational, Object Relational, And Object Oriented Database Systems Paper presented at 2009 Annual Conference & Exposition, Austin, Texas. 10.18260/1-2--5131

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2009 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015