🎓 Free Capstone Projects with Full Documentation, ER Diagrams & Source Code — Updated Weekly for 2026
👨‍💻 Free Source Code & Capstone Projects for Developers

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

🏥 Hospital, Pharmacy & Healthcare

🍽️ Hotel, Restaurant & Hospitality

🛒 E-commerce, Shop & Inventory

🏦 ATM, Banking & Finance

🚗 Transport, Travel & Reservation

🛡️ Government & Civic

How to draw an ER diagram for your capstone (5 steps)

  1. List your entities — every “thing” your system stores. Nouns from your problem statement become entities (Student, Book, Loan, Borrower).
  2. Add attributes — what data does each entity hold? Mark the primary key (PK). For Student: student_id (PK), name, email, year_level.
  3. Identify relationships — which entities connect? Use verbs (Student enrolls in Course; Doctor treats Patient).
  4. 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).
  5. 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

ER Diagram for Online Hotel Reservation System

by
ER Diagram of 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 …

Read more

ER Diagram for Restaurant Management System

by
ER Diagram of 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 …

Read more

ER Diagram for E-commerce Website

by
E-Commerce Website ER Diagram

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 …

Read more

Railway Management System ER Diagram

by
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 …

Read more

ER Diagram for Payroll Management System

by
ER Diagram for Payroll Management System

This template is an ER diagram for employee payroll management system. It makes it easy for the business to manage the distribution of employees through the management system. As the …

Read more

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.

Itsourcecode.com is your trusted resource for free source code, capstone projects with full documentation, and step-by-step programming tutorials.

Built by PIES IT Solutions

Binalbagan, Negros Occidental, Philippines

Quick Links

Top Categories

Get Free Capstone Resources

Subscribe for weekly updates and free resources delivered to your inbox.

© 2026 Itsourcecode.com | All rights reserved|
Built with ❤️ by PIES Information Technology Solutions