ER Diagram for Hospital Management System (with SQL Schema)
Hospital Management System is a top-5 BSIT capstone topic in 2026, and the ER diagram is where your database design becomes defensible. Without a strong ER diagram in Chapter 3, …
ER Diagram Examples: 35+ Free Entity-Relationship Diagrams for BSIT Capstones (2026)
itsourcecode.com hosts 35+ free Entity-Relationship Diagram (ERD) examples for BSIT capstone projects (2026): complete with entities, attributes, relationships, primary keys, and foreign keys for the most common capstone domains. Each diagram is downloadable and capstone-ready for inclusion in your Chapter 3 (Methodology) documentation. Browse by system domain below.
What is an ER Diagram?
An Entity-Relationship Diagram (ERD) is a graphical representation of the data structure in a database system. It shows: (1) Entities: the things you store (Student, Book, Order). (2) Attributes: the properties of each entity (student_id, name, email). (3) Relationships: how entities connect (a Student enrolls in many Courses). (4) Cardinality: whether relationships are one-to-one, one-to-many, or many-to-many. ERDs are mandatory in Chapter 3 of every BSIT capstone in the Philippines, India, and most Asian universities.
Featured ER diagrams by system domain
🎓 School, Student & Library
ER Diagram for Student Management System
Student Registration System ERD
School Management System ERD
College Management System ERD
University Management System ERD
College Library Management ERD
Enrollment System ERD
Online Examination System ERD
🏥 Hospital, Pharmacy & Healthcare
Pharmacy Management System ERD
Blood Bank Management ERD
Gym Management System ERD
🍽️ Hotel, Restaurant & Hospitality
Online Hotel Reservation ERD
Restaurant Management ERD
Online Food Ordering ERD
Movie Ticket Booking ERD
🛒 E-commerce, Shop & Inventory
E-commerce Website ERD
Online Shopping System ERD
🏦 ATM, Banking & Finance
ATM Management System ERD
Loan Management System ERD
Payroll Management System ERD
Employee Attendance ERD
Attendance Management ERD
Employee Management ERD
🚗 Transport, Travel & Reservation
Railway Management System ERD
Railway Reservation ERD
Airline Reservation ERD
Bus Reservation ERD
Car Rental System ERD
🛡️ Government & Civic
Barangay Information System ERD
How to draw an ER diagram for your capstone (5 steps)
List your entities: every “thing” your system stores. Nouns from your problem statement become entities (Student, Book, Loan, Borrower).
Add attributes: what data does each entity hold? Mark the primary key (PK). For Student: student_id (PK), name, email, year_level.
Identify relationships: which entities connect? Use verbs (Student enrolls in Course; Doctor treats Patient).
Mark cardinality: 1:1, 1:N, or N:M. Most capstone systems use 1:N (one student has many enrollment records) and N:M (resolved by junction tables).
Normalize to 3NF: eliminate redundancy. Move repeating groups to their own tables. Document your normalization decisions in Chapter 3 for the panel.
About this ER diagram collection
Curated since 2015 by PIES Information Technology Solutions, Binalbagan, Negros Occidental, Philippines. Every ERD has been used in defended capstones. Used by 12,000+ BSIT students monthly. Pair each ERD with the matching Database Design schema and DFD for a complete Chapter 3 documentation set.
Related UML diagram collections
UML Diagrams Library, parent collection, 300+ diagrams across all types
Data Flow Diagrams (DFD), 40+ DFDs paired with these ERDs
Use Case Diagrams, 40+ Use Case diagrams
Class Diagrams, 30+ object-oriented class diagrams
Activity Diagrams, 30+ behavioral activity diagrams
Sequence Diagrams, 35+ object interaction diagrams
Components Diagrams, 25+ component architecture diagrams
Deployment Diagrams, 25+ deployment topology diagrams
Database Design Projects, 35+ SQL schemas paired with these ERDs
Final Year Projects, full capstone packages with documentation
ER Diagram for Online Hotel Reservation System
The Online Hotel Reservation System ER Diagram is the project’s database design that reveals the relationships of the hotel reservation entities. This describes the logical structure of the system’s database …
ER Diagram for Online Food Ordering System
This article will explain, step by step, how to make the entity relationship diagram (ERD) for the Online Food Ordering System ER Diagram. The Online Food Ordering System capstone project …
ER Diagram for Restaurant Management System
The model of the simple ER diagram for restaurant management system is shown in this ER (Entity Relationship) Diagram. The Restaurant Management System’s entity-relationship diagram shows all of the database …
Online Examination System ER Diagram 2026: Complete Database Design [Free PDF Download]
The Online Examination System ER Diagram shows the relationships of the system’s entities that build its database design. ER diagram describes the logical structure of the system’s database or data …
Gym Management System ER Diagram 2026: Complete Database Design [Free PDF]
This article will talk about how to make the gym management system project ER diagram step by step. The first step in making the Gym Management System is to make …
ER Diagram for ATM System | Entity Relationship Diagram
The ER diagram for ATM management system shows the relationships of the ATM transaction and process entities that build its database design. This ER diagram is done by identifying the …
ER Diagram for E-commerce Website
The E-commerce Website ER Diagram site shows how it uses database design to handle data used for e-commerce management tasks (ERD). It shows how the database links the different parts …
ER Diagram for Employee Attendance Management System
The employee attendance management system ER diagram shows the relationships of the system’s entities that build its database design. It is done by identifying the employee attendance management process entities, …
Attendance Management System ER Diagram 2026: Complete Database Design [Free PDF Download]
The attendance management system ER diagram reveals the relationships of the system’s entities to create its database design. It is also used to describe the logical structure of the system’s …
Railway Management System ER Diagram
This ER (Entity Relationship) Diagram shows how the model of the Railway Management System ERD is put together. The entity-relationship diagram for the Railway Management System shows the visual parts …
Pharmacy Management System ER Diagram 2026: Complete Database Design [Free PDF Download]
The model of the Pharmacy Management System ER Diagram is shown in this ER (Entity Relationship) Diagram. It shows all of the database tables and the connections between customers, pharmacists, …
Employee Management System ER Diagram 2026: Complete Database Design [Free PDF Download]
The employee management system ER diagram shows the relationships of the system’s entities that build its database design. ER diagram describes the logical structure of the system’s database or data …
Frequently Asked Questions
What is the difference between ER Diagram and UML Class Diagram?
An ER Diagram models the database — entities, attributes, primary/foreign keys, relationships with cardinality. A UML Class Diagram models the code — classes with attributes AND methods, plus inheritance, association, aggregation, and composition. They often look similar but represent different things. Most capstones include BOTH: ERD for Chapter 3 database design, Class Diagram for code architecture.
Which ER notation should I use — Crow's Foot or Chen?
Crow's Foot is the modern default — used by MySQL Workbench, dbdiagram.io, draw.io, and most enterprise tools. Easier to read at a glance, cardinality is visible from the line endings. Chen notation (the round-ellipses style) is academically traditional but visually verbose. Use Crow's Foot unless your school's documentation template specifically requires Chen.
What is cardinality and how do I mark it?
Cardinality describes how many of one entity relate to another. (1) One-to-One (1:1) — one Department has one Department Head. (2) One-to-Many (1:N) — one Customer has many Orders. (3) Many-to-Many (N:M) — many Students enroll in many Courses (resolved by a junction table). In Crow's Foot, the line endings show cardinality: single dash = one, crow's foot = many, circle = optional, dash = mandatory.
What is normalization and which form do I need?
Normalization eliminates redundant data. 1NF: no repeating columns (no Phone1, Phone2, Phone3 — use a separate Phones table). 2NF: no partial dependency on a composite key. 3NF: no transitive dependency (department_name should not be in the Employee table — link to a Department table). Most BSIT capstones target 3NF. BCNF and beyond are overkill unless your panel specifically asks.
What free tool should I use to draw an ER Diagram?
MySQL Workbench — free, generates SQL DDL directly from the diagram. dbdiagram.io — free, text-based, fast iteration, exports as PNG/PDF. draw.io — most general-purpose, free, web-based. Visual Paradigm Community — for UML-style ER diagrams. Pick MySQL Workbench if you want SQL generation; pick draw.io if you want fastest iteration.
Are these ER diagrams free for capstone use?
Yes. All ERDs are free to download, modify, and use in your capstone. Adapt the entities and attributes to your specific system — that is expected and reduces plagiarism risk. Panels appreciate when you can defend WHY you added or removed certain attributes.
How often is this ER diagram collection updated?
New ER diagrams are added regularly as we encounter new capstone domains (Telemedicine, Online Voting, IoT systems). Existing diagrams are revised when database design best practices evolve. Last refreshed: May 2026.