About This Architecture
University System ER diagram models a complete academic institution with seven core entities: Aluno (Student), Curso (Course), Disciplina (Discipline), Professor, Departamento (Department), Bolsa (Scholarship), and Matricula (Enrollment). Students enroll in courses through a many-to-many Matricula relationship with Disciplines, while Professors teach Disciplines within Departments and Students may hold optional Scholarships. This normalized schema enforces referential integrity through primary and foreign keys, supporting queries on student progress, course prerequisites, professor assignments, and scholarship allocation. Fork and customize this diagram on Diagrams.so to adapt it for your institution's specific academic structure, accreditation requirements, or reporting needs. The optional relationship on Bolsa (id_bolsa nullable) and Disciplina prerequisites (id_prereq nullable) reflect real-world flexibility in scholarship eligibility and course sequencing.