CIS 515 Assignment 3
Assignment 3: University Database
Veronica Hocutt
Strayer University
Dr. Darcel Ford
CIS 515
July 22, 2014
Abstract
A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. As the database consultant it will be necessary to assist with the development of a design strategy for student records. The following has been determined after meeting with various university subject matter experts:
Faculty groups are divided by core competencies that the university offers.
Courses are categorized by course code and title. Certain courses have prerequisites and the university has asked for this to be cataloged as well.
There are various schools within each campus.
The study path for students requires that they be enrolled in a specific professional study program. The professional study program requires the students to complete a specific set of core courses. The university also requires that an online grade book be available. The online grade book should show grades awarded to students for specific courses and the term they completed the course.
The university identifies each student by his or her name, date of birth, social, and professional study program.
Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Refer to Figure 1
Figure 1
Describe any assumptions or limitations for each relationship. The assumptions are the professors can teach multiple classes but the limitation is each professor is limited to teaching at one specific campus and school.
Create the primary key and foreign keys using a UML Class diagram for each table. Refer to Figure 2
Figure 1
Suggest at least four (4) types of business intelligence reports.
Veronica Hocutt
Strayer University
Dr. Darcel Ford
CIS 515
July 22, 2014
Abstract
A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. As the database consultant it will be necessary to assist with the development of a design strategy for student records. The following has been determined after meeting with various university subject matter experts:
Faculty groups are divided by core competencies that the university offers.
Courses are categorized by course code and title. Certain courses have prerequisites and the university has asked for this to be cataloged as well.
There are various schools within each campus.
The study path for students requires that they be enrolled in a specific professional study program. The professional study program requires the students to complete a specific set of core courses. The university also requires that an online grade book be available. The online grade book should show grades awarded to students for specific courses and the term they completed the course.
The university identifies each student by his or her name, date of birth, social, and professional study program.
Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Refer to Figure 1
Figure 1
Describe any assumptions or limitations for each relationship. The assumptions are the professors can teach multiple classes but the limitation is each professor is limited to teaching at one specific campus and school.
Create the primary key and foreign keys using a UML Class diagram for each table. Refer to Figure 2
Figure 1
Suggest at least four (4) types of business intelligence reports.
References: Orbund. (2014). Introduction to Orbund. Retrieved from Orbund: http://www.orbund.com/architecture.html Research, M. (2012). Five Different Kinds of Business Intelligence. A Monash Research Publication. Solutions, S. C. (2013). Stars Features. Retrieved from Stars Campus Solutions: http://starscampus.com/features/ Systems, T. R. (2012). About CAMS Enterprise. Retrieved from Three Rivers Systems: http://www.threerivers-cams.com/