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.
Recommended Citation
Tran, Andrew, "College of Education FileMaker Extraction and End-User Database Development" (2022). Electronic Theses, Projects, and Dissertations. 1385.
https://scholarworks.lib.csusb.edu/etd/1385
Included in
Databases and Information Systems Commons, Data Science Commons, Graphics and Human Computer Interfaces Commons, Information Security Commons