Cis 515week 3
Cis 515week 3
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 forecast enrollment increases and decreased based on historical data. In many cases, “BI tool helped to use data and trend analysis to
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 forecast enrollment increases and decreased based on historical data. In many cases, “BI tool helped to use data and trend analysis to
Bibliography: (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino. Powers, V. (2011, November). Business intelligence gets smarter. Retrieved from http://www.universitybusiness.com/article/business-intelligence-gets-smarter Barron, K. (2013, May 13). Columbus state university implements data warehouse and business intelligence environment to improve student retention and graduation rates. Retrieved from http://www.oracle.com/us/corporate/press/1946491 Banner. (2013). Banner by ellucian. Retrieved from http://www.ellucian.com/student-information-system/ Kinetic. (2013). Kx student. Retrieved from http://www.kxsoftware.com/solutions/5/kxstudent housing software/ Janzabar. (2013). Our erp solutions drive operational performance.. Retrieved from http://www.jenzabar.com/higher-ed-solutions/enterprise-resource-planning-erp