About This Architecture

Entity-Relationship Diagram (ERD) for a complete university management system modeling students, courses, disciplines, professors, departments, scholarships, and academic prerequisites. The schema captures core entities—ALUNO, CURSO, DISCIPLINA, PROFESSOR, DEPARTAMENTO, BOLSA—with associative entities MATRICULA and CURSADA managing many-to-many relationships and academic performance tracking. Data flows from student enrollment through course registration and discipline completion, with prerequisite constraints enforced via the PRE-REQUISITO self-referencing entity. This normalized design supports institutional reporting, transcript generation, and enrollment validation while maintaining referential integrity across all academic operations. Fork and customize this diagram on Diagrams.so to adapt it for your institution's specific data model, add additional attributes, or export as .drawio or PNG for documentation and stakeholder review.

People also ask

How do you design a database schema for a university student information system with courses, disciplines, prerequisites, and enrollment tracking?

This ERD models a complete university system using core entities (ALUNO, CURSO, DISCIPLINA, PROFESSOR, DEPARTAMENTO, BOLSA) connected through associative entities MATRICULA and CURSADA to manage many-to-many relationships. The PRE-REQUISITO self-referencing entity enforces discipline prerequisites, while normalized relationships ensure data integrity across enrollment, transcript, and academic per