University Management Software
CIS 515
Strayer University

Abstract This study examines the requirements for a consolidation strategy to centralize all student records for a prestigious university. As a result, this study will develop a data model to retain student records and allow data extraction and load processes, formulate a data structure entity relationship model for the data structure, show how business intelligence reports can help the university and examine and recommend software solutions for the university to utilize.

Entity Relationship Model In order to properly indentify the university’s requirements and create an accurate proposal, the first step should be to create and Entity Relationship Model (ERM). The ERM will provide a visual representation of the data structure of the data stores and show the relationships between the data. The following diagram displays the ERM:

The above ERM represents the data store relationships that are based on several assumptions. The first assumption is that the faculty is capable of teaching more than one course and that students can only enroll in one course curriculum. Another assumption is that faculty only teach at one campus and that teach faculty is assigned one Dean. Finally, another assumption is that some campuses have particular schools, whereas others do not. Therefore, the data represented in the ERM shows that relationships between the data structure, but it is based on assumptions that must be taken into account for the final proposal of the university’s requirements.
Business Intelligence Reports Having data to base decision on is an important step in improving the business model and utilizing business intelligence to improve functions and services is critical to that end. In this case, the university can utilize business intelligence reports to