As the database consultant, I will need to help develop a design strategy for managing student records. After meeting with experts from the university, the following findings have been made: Faculty groups are organized based on the core competencies offered by the university. Courses are classified by their course code and title, and some courses have prerequisites that need to be recorded. Additionally, each campus has multiple schools.
The study path for students mandates enrollment in a designated professional study program, which includes completion of core courses. In addition, the university necessitates the availability of an online grade book that displays students’ course grades and the corresponding term. Each student is identified by their name, date of birth, social security number, and professional study program.
Provide an Entity Relationship Model (ERM) that describes the data structure for storing all data elements. See Figure 1 for reference.
Figure 1: Describe the assumptions and limitations for each relationship. It is assumed that professors can teach multiple classes, but they are limited to teaching at one specific campus and school.
Create primary keys and foreign keys using a ML Class diagram for each table. See Figure 2 for reference.
Suggest at least four (4) types of business intelligence reports.
Within the realm of database management systems, a particular database manager has devised customized business intelligence reports specifically tailored to database management. Presented below are four out of the total five business intelligence reports pertaining to database management: Real-time (ideally with descriptors like “quasi” or “human”), Tactical (or task-centric), Investigative (or exploratory), and Traditional. Additionally, three vendors for registrar and school management database systems are recommended.
In the database management system world, a database manager developed personalized business intelligence reports for Rebound, an industry-leading education software company. Rebound is committed to offering flexible and highly-functional Student Information Systems to various education institutions, ranging from traditional universities to vocational training centers.
Rebounds Einstein System offers a unified platform for administrators, staff, instructors, and students. This platform enables administrators and staff to manage institutions without the hassle of transferring records between systems. Instructors can access the Rebounds Einstein System instructor portal from any web-connected computer to prepare lesson plans and perform other tasks. Students can conveniently view their progress reports, participate in class discussion groups, take quizzes, and submit homework assignments through the Rebounds Einstein System student portal.
Streamline Operations? Rebounds offers a Software-as-a-Service approach that allows for customized solutions to meet the unique needs of each client. With Rebounds Einstein system, institutions can seamlessly integrate events, announcements, and staff directories onto their websites. The system is also capable of supporting international standards and multiple languages. This provides administrators with numerous benefits, as they can easily view and manage all operational and academic activities and records through a secure web environment accessible from any internet-connected computer.
Administrators have several benefits, including the ability to use powerful, real-time reporting tools, view and maintain student, teacher, and staff records, manage admissions and the application process, and view past and current grade reports. Instructors using the Einstein system can also manage class activities, prepare lesson plans, post quizzes, receive homework online, and keep track of student immunizations. Additionally, progress reports can be automatically generated to help teachers support students in improving their performance in class.
Some of the features for instructors include maintaining grosbeaks, creating and updating lesson plans, logging attendance, and maintaining progress reports. The Einstein System allows students to follow their academic progress in their classes. Students are given a surname and password to access their academic records from any internet-connected computer. Some of the features for students include tracking homework assignments, communicating with peers and instructors, viewing grades, and viewing academic reports (Rebound, 2014). Another registrar and school management database systems vendor to consider is Three Rivers Systems.
Three Rivers Systems, established in 1985, provides administrative solutions for higher education. One of their offerings is the CAM, which is a comprehensive academic management system for colleges and universities globally. This system efficiently handles the complete student lifecycle, from initial contact with prospective students to graduation and alumni relations. It combines various functionalities into a single solution, including Admissions/CRM, Registration, Financial Aid, and Fiscal Management.
Three Rivers Systems has been a trusted partner of higher education institutions for over 25 years, offering complete implementation, training, project management, and support services for CAMS academic enterprise resource planning (ERP) solution. Another competitor to consider is Stars Campus Solutions.
STARS@ is a cloud-based campus management system that securely and reliably maintains operational data for colleges and schools. This school information system covers the entire student life cycle from lead to placement and provides key school performance data at your fingertips. The reliability of the STARS school management system is unparalleled. (Solutions, 2013) Compare and contrast the key aspects that each system offers.
Each system offered by the three vendors has an overwhelming number of key aspects. All three vendors highlight similarities, such as instructor grade books, attendance scanning, email and testing capabilities, student financial tracking, and student academic record keeping. Two out of the three vendors also provide a loud service as a key aspect of their systems. For some companies, as their business continues to grow, the cloud has become the solution for storing large files.
