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. Imagine that you have
been hired as a database consultant to assist in the development of a data design strategy for the student
records.
You met with various university subject matter experts and have determined the following after performing
various business analysis processes:
Faculty groups are divided by core competencies that the university offers. For example, there are groups such
as the Art Faculty, Computer Technology Faculty, Language Faculty, and Science Faculty. Each faculty
member has an assigned Dean and is designated to teach at one particular campus and school. They are able
to teach as many courses as required.
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. For example, the Los Angeles campus holds the following
schools: School of Science, School of Law, and School of Computer Technology. Additionally, each school
offers different professional study programs, such as Forensic Computer Science, Marine Biology, Business
Management, and Civil Engineering, to name a few.
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 their name, date of birth, social, and professional study program.
Instructions
Suggest at least four types of business intelligence reports that could help the university in course
management, student enrollment, or historical tracking. Support your answer by providing specific business
functions that these reports could be used for to assist executives of the university.
Consider outsourcing the functions above as an alternative for development of the database. Research the
Internet and other media sources for vendors who develop registrar and school management database
systems.
Suggest three vendors that developed and are employing efficient registrar and school management database
systems and support your reasons to choose from one of these three vendors.
Compare and contrast the key aspects that each system offers. Examples of system aspects include but are
not limited to cloud based, pricing model, open source, et cetera.
Sample Solution