California State University San Bernardino Department of Computer Science and Engineering
Independent Study Presentation

Date 03.09.09
Time 10.00am bm
Place JB-391

Title Conceptual & Logical Modeling for a University Registration System

Candidate Kalaivani Nellaiappan

Advisor Dr. Josephine Mendoza

Committee Members Dr. Richard J. Botting Dr. Ernesto Gomez Dr. David A. Turner

Abstract

This project concerns the creation of  a database management system for a 
university registration system, which is the universe of interest for the 
project. Database design and modeling was done in two stages using a 
heuristic and intuitive  approach. The first stage consisted of 
transforming the business rules into  a conceptual data model using the 
entity-relationship modeling technique, which is technology independent. 
The second stage was concerned with the transformation of the conceptual 
schema into a logical schema using the relational modeling method, which is
technology dependent. Finally, a validation of the design was done using 
the normalization technique to check for redundancies, which is the common
cause of inconsistencies in a database system. The developed model ensures
data integrity, flexibility and program-data independence and thereby 
facilitates efficient backup and security standards. A database system can
now be implemented with the developed model using any of the procedural 
language extensions.