NotesFAQContact Us
Collection
Advanced
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1145604
Record Type: Journal
Publication Date: 2011-Sep
Pages: 11
Abstractor: As Provided
Reference Count: 18
ISBN: N/A
ISSN: EISSN-1545-679X
Solving Relational Database Problems with ORDBMS in an Advanced Database Course
Wang, Ming
Information Systems Education Journal, v9 n4 p80-90 Sep 2011
This paper introduces how to use the object-relational database management system (ORDBMS) to solve relational database (RDB) problems in an advanced database course. The purpose of the paper is to provide a guideline for database instructors who desire to incorporate the ORDB technology in their traditional database courses. The paper presents how to use the specific object-relational database (ORDB) technology to solve three normalization problems: Transitive dependency, Multi-value attributes, and Non-1st Normal Form. The paper also provides the solutions to data complexity problems with three specific ORDBMS techniques: object view, object inheritance, and object integration. The paper summarizes the significance and advantages of teaching ORDBMSs in advanced database courses. Course contents and students' learning outcomes are discussed. To be more helpful to database educators, the paper presents a complete object-relational database development case study from the UML class diagram design to Oracle ORDBMS implementation.
Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
Publication Type: Journal Articles; Reports - Evaluative
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A