Date of Award

5-2022

Document Type

Project

Degree Name

Master of Science in Computer Science

Department

School of Computer Science and Engineering

First Reader/Committee Chair

Qiao, Haiyan

Abstract

The College of Education (CoE) at the California State University San Bernardino (CSUSB) developed a system to keep track of both state and national accreditation requirements using FileMaker 5, a database system. This accreditation data is crucial for reporting and record-keeping for the CSU Chancellor’s Office as well as the State of California. However, the database system was developed several decades ago, and software support has long since been dropped, causing the CoE’s legacy accreditation data to be at risk of being lost should the software or hardware suffer permanent failure. The purpose of this project was to perform extraction of the raw data in this legacy system, develop a new database to clean and house this raw data, as well as develop a newer and more efficient end-user interface for the CoE to retrieve the data. Raw data analysis, consultation, and extraction are performed first and are followed by database design and development using Oracle SQL and PL/SQL. At the same time, the end-user interface and reporting tool was developed using Oracle PeopleSoft. This project aimed to extract critical data from the outdated and no longer supported legacy database while providing the CoE with an efficient means to access the data for reporting needs.

Share

COinS