Assignment 3: University Database
Dr. Darcel Ford
July 22, 2014
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
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
Suggest at least four (4) types of business intelligence reports. In the database management system world one database manager came up with his personalized business intelligence reports that would apply to database management. Below are 4 of the 5 business intelligence reports as it relates to database management: (Research, 2012) Real-time (preferably with a modifier such as “quasi” or “human”) Tactical (or task-oriented/-centric)
Investigative (or exploratory)
Three suggested registrar and school management database systems vendors. In the database management system world one database manager came up with his personalized business intelligence reports that would apply to database management. Below are 4 of the 5 business intelligence reports as it relates to database management: (Research, 2012) Real-time (preferably with a modifier such as “quasi” or “human”) Tactical (or task-oriented/-centric)
Investigative (or exploratory)
Three suggested registrar and school management database systems vendors. Orbund is an industry-leading education software firm dedicated to providing flexible and highly-functional, easy-to-use Student Information Systems for many different types of education institutions, from traditional universities to vocational training centers. Orbund’s Einstein System allows all administrators and staff to manager institutions through ONE platform, eliminating the need to transfer records from one system to another. Instructors can access gradebooks and prepare lesson plans from any web-connected computer through Orbund’s Einstein System instructor portal. Students can view their progress reports in real time, participate in class discussion groups, take quizzes, and submit homework assignments, all online through Orbund’s Einstein System student portal. Streamline Operations—Orbund’s hosted, Software-as-a-Service approach allows unique solutions to be created each client’s unique needs. Flexible Solutions—Orbund’s Einstein system...
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/
Please join StudyMode to read the full document