CSUniversity San Bernardino
College of Education FileMaker Extraction and End-User Database Development
Abstract
dc:description.abstractThe 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 × 9Identifiers
dc:identifier.*- Repository record dc:identifier
- https://scholarworks.lib.csusb.edu/etd/1385