Back to search

CSUniversity San Bernardino

College of Education FileMaker Extraction and End-User Database Development

Abstract

dc:description.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.

Degree

thesis:*
Name thesis:degree_name
Master of Science in Computer Science
Level thesis:degree_level
Project
Discipline thesis:degree_discipline
School of Computer Science and Engineering

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Tran, Andrew
Contributors dc:contributor
  • Qiao, Haiyan

Subjects

dc:subject × 9

Identifiers

dc:identifier.*
Repository record dc:identifier
https://scholarworks.lib.csusb.edu/etd/1385

Chain of custody

source
Harvested from
CSUniversity San Bernardino
Base URL
scholarworks.lib.csusb.edu/do/oai/
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Tran, Andrew. College of Education FileMaker Extraction and End-User Database Development. Project thesis, https://scholarworks.lib.csusb.edu/etd/1385