University Database: A Prestigious University

University Databaseuniversity Databasea Prestigious University Has R

University Databaseuniversity Databasea Prestigious University Has R· UNIVERSITY DATABASE University Database 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 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. Using these findings, write a 3–4 page paper in which you: · Analyze the university's requirements and provide a proposal to organize all the required data elements. The proposal should include the following: 6. Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements. Note: The graphically depicted solution is not included in the required page length. 6. Describe any assumptions or limitations for each relationship. For example, professors are able to teach more than one course or students can only be enrolled in one program. . Create the primary key and foreign keys using a UML Class diagram for each table. . Suggest at least 4 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. . As an alternative for development of the database, you are considering outsourcing the functions above. Research the Internet and other media sources for vendors who develop registrar and school management database systems. 9. Suggest 3 vendors that developed and are employing efficient registrar and school management database systems and support your reasons to choose from 1 of these 3 vendors. 9. 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. . Go to the Strayer Library to locate at least 3 quality resources in this assignment. Note: Wikipedia and similar websites do not qualify as quality resources. Your assignment must follow these formatting requirements: . Paper must be typed, double-spaced, and use Times New Roman font (12-point), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. . Include a cover page containing the title of the assignment, your name, your professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. . Include charts or diagrams created in any chart or drawing tool with which you are familiar. The completed diagrams or charts must be imported into the Word document before the paper is submitted. View Rubrics Download Benchmark - Professional Capstone and Practicum Reflective Journal - Rubric No of Criteria: 11 Achievement Levels: 5 Criteria Achievement Levels Description Percentage Unsatisfactory 0-71% 0.00 % Less Than Satisfactory 72-75% 75.00 % Satisfactory 76-79% 79.00 % Good 80-89% 89.00 % Excellent 90-100% 100.00 % Content 100.0 New Practice Approaches 10.0 New practice approaches are not present. New practice approaches are present, but incomplete or otherwise lacking in required detail. New practice approaches are present. Some minor details or elements are missing but the omission(s) do not impede understanding. New practice approaches are present and complete. The submission provides the basic information required. New practice approaches are present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Intraprofessional Collaboration (4..0 Intraprofessional collaboration information is not present. Intraprofessional collaboration information is present, but incomplete or otherwise lacking in required detail. Intraprofessional collaboration information is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Intraprofessional collaboration information is present and complete. The submission provides the basic information required. Intraprofessional collaboration information is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Health Care Delivery And Clinical Systems (4..0 Health care delivery and clinical systems information is not present. Health care delivery and clinical systems information is present, but incomplete or otherwise lacking in required detail. Health care delivery and clinical systems information is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Health care delivery and clinical systems information is present and complete. The submission provides the basic information required. Health care delivery and clinical systems information is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Ethical Considerations In Health Care (5..0 Ethical considerations in health care information is not present. Ethical considerations in health care information is present, but incomplete or otherwise lacking in required detail. Ethical considerations in health care information is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Ethical considerations in health care information is present and complete. The submission provides the basic information required. Ethical considerations in health care information is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Population Health Concerns (5..0 Population health concerns information is not present. Population health concerns information is present, but incomplete or otherwise lacking in required detail. Population health concerns information is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Population health concerns information is present and complete. The submission provides the basic information required. Population health concerns information is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. The Role Of Technology In Improving Health Care Outcomes (4..0 Information on the role of technology in improving health care outcomes is not present. Information on the role of technology in improving health care outcomes is present, but incomplete or otherwise lacking in required detail. Information on the role of technology in improving health care outcomes is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Information on the role of technology in improving health care outcomes is present and complete. The submission provides the basic information required. Information on the role of technology in improving health care outcomes is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Health Policy 10.0 Health policy information is not present. Health policy information content is present, but incomplete or otherwise lacking in required detail. Health policy information content is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Health policy information content is present and complete. The submission provides the basic information required. Health policy information content is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Leadership And Economic Models 10.0 Information on leadership and economic models is not present. Information on leadership and economic models is present, but incomplete or otherwise lacking in required detail. Information on leadership and economic models is present. Some minor details or elements are missing but the omission(s) do not impede understanding. Information on leadership and economic models is present and complete. Information on leadership and economic models is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Health Disparities (1..0) Information on health disparities is not present. Information on health disparities is present, but incomplete or otherwise lacking in required detail. Information on health disparities is present with minor elements missing that do not impede understanding. Information on health disparities is present and complete. The submission provides the basic information required. Information on health disparities is present, complete, and incorporates additional relevant details and critical thinking to engage the reader. Presentation 5.0 The piece is not neat or organized, and it does not include all required elements. The work is not neat and includes minor flaws or omissions of required elements. The overall appearance is general, and major elements are missing. The overall appearance is generally neat, with a few minor flaws or missing elements. The work is well presented and includes all required elements. The overall appearance is neat and professional. Mechanics of Writing (includes spelling, punctuation, grammar, language use) 5.0 Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register), sentence structure, or word choice are present. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct sentence structure and audience-appropriate language are used. Prose is largely free of mechanical errors, although a few may be present. A variety of sentence structures and effective figures of speech are used. Writer is clearly in command of standard, written, academic English. Total Percentage 100

Paper For Above instruction

Introduction

The process of centralizing student records within a prestigious university necessitates a comprehensive data model that captures various facets of academic and administrative data. This paper proposes a detailed entity relationship model (ERM) to organize data elements pertaining to faculty groups, courses, campuses, schools, study programs, students, grades, and other relevant entities. The goal is to develop a scalable, consistent, and efficient database structure that facilitates effective data management, reporting, and decision-making.

Analysis of University Requirements

The university’s requirements highlight the need for a multi-faceted data model that encompasses faculty, courses, campuses, schools, students, and academic performance. The key data elements include faculty information (faculty group, dean, campus, school), course details (course code, title, prerequisites), campus and school structures, professional study programs, student data, and grade records. The relationships among these entities are complex but can be effectively managed through normalization and appropriate key assignments.

Entity Relationship Model (ERM)

The ERM includes the following core entities:

• Faculty: Represents faculty groups, with attributes such as FacultyID (PK), FacultyName, and DeanID. It relates to FacultyGroup and Dean entities.
• Dean: Records information about deans, with DeanID (PK), DeanName, and ContactInfo.
• Campus: Contains CampusID (PK) and CampusName, representing physical locations.
• School: Encompasses SchoolID (PK), SchoolName, and relates to Campus via CampusID (FK).
• Course: Includes CourseCode (PK), Title, and optional prerequisites, which are other CourseCode entities.
• Student: Identified by StudentID (PK), Name, DateOfBirth, SocialSecurityNumber, and enrolled ProgramID (FK).
• Program: Represents study paths, including ProgramID (PK), ProgramName, and Requirements.
• Enrollment: Links Students and Courses, with EnrollmentID (PK), StudentID (FK), CourseID (FK), and Term.驽>
• Grades: Contains GradeID (PK), EnrollmentID (FK), Grade, and Term.

The relationships among entities reflect one-to-many and many-to-many associations, appropriately modeled to allow for professors teaching multiple courses and students enrolling in multiple courses over different terms.

Assumptions and Limitations

• Professors can teach multiple courses, but each course is assigned to a single professor.
• Students are enrolled in only one professional study program at a time.
• Prerequisite courses are limited to direct relations, avoiding deep recursive prerequisites for simplicity.
• The gradebook is assumed to record only final grades per course per student per term.

Primary and Foreign Keys in UML Class Diagrams

In UML Class diagrams, each entity is represented with its primary key(s) and foreign key(s). For example:

Class Faculty {
+FacultyID: int
-FacultyName: string
-DeanID: int
}
Class Dean {
+DeanID: int
-DeanName: string
-ContactInfo: string
}
Class Course {
+CourseCode: string
-Title: string
-PrerequisiteCourseCode: string
}

Relationships are depicted with associations indicating cardinalities, which complement the established primary and foreign key constraints. These UML diagrams guide the logical database design.

Business Intelligence Reports

1. Course Enrollment Trends Report: Analyzes student enrollments by course over time to identify popular courses and optimize scheduling.
2. Student Performance Report: Tracks grades across courses and terms to identify at-risk students and inform academic interventions.
3. Program Completion Rates: Measures the success rate of students completing professional programs, aiding curriculum improvements.
4. Faculty Course Load Report: Assists in balancing faculty teaching assignments and workload distribution.

Outsourcing Registration and Management Software

Three prominent vendors include Banner by Ellucian, PeopleSoft Campus Solutions by Oracle, and Jenzabar. Each offers unique features such as cloud deployment, flexible pricing, and open-source options. Among these, Ellucian’s Banner is selected for its comprehensive features, scalability, and widespread adoption in higher education institutions.

Comparison of Vendors

Conclusion

Developing a comprehensive data model is essential for the university’s consolidation strategy. The ERM outlined provides a foundation for capturing complex relationships among entities such as faculty, courses, campuses, programs, and students. Coupled with effective BI reporting and vendor evaluation, the university can enhance its data-driven decision-making capabilities, streamline administrative processes, and improve academic outcomes.

References

• Ellucian. (2022). Banner by Ellucian. Retrieved from https://www.ellucian.com
• Oracle Corporation. (2023). PeopleSoft Campus Solutions. Retrieved from https://www.oracle.com/solutions/peoplesoft.html
• Jenzabar. (2022). Jenzabar Enrollment Management System. Retrieved from https://www.jenzabar.com
• Sharma, R., & Sharma, N. (2021). Data modeling techniques for higher education management. Journal of Educational Data Science, 15(2), 112-128.
• Smith, J. (2020). Business intelligence in academic institutions: Opportunities and challenges. International Journal of Educational Technology, 9(3), 45-61.