ER Diagram for Online Shopping System
The ER diagram for the online shopping management system shows the entities’ relationships to form the database design. It is also used to describe the logical structure of the system’s …
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
🍽️ Hotel, Restaurant & Hospitality
- Online Hotel Reservation ERD
- Restaurant Management ERD
- Online Food Ordering ERD
- Movie Ticket Booking ERD
🛒 E-commerce, Shop & Inventory
🏦 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
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 Loan Management System
The loan management system ER diagrams shows the relationships of the loan management entities within its database. This describes the logical structure of the system’s database or data storage. It …
ER Diagram for Blood Bank Management System
The blood bank management system ER diagram shows the entities’ relationships to form the database design. It is also used to describe the logical structure of the system’s database or …
ER Diagram for Hotel Management System
ER diagram for hotel management system in DBMS illustrates how database elements are related. This shows how the system’s database or data storage is put together logically. It is done …
ER Diagram for Online Ordering System
The online ordering system’s entity relationship (ER) diagram translates system entities into a database. This describes the logical structure of the system’s database or data storage. It is done by …
ER Diagram for Bank Management System
The ER diagram for the bank management system in DBMS reveals the relationships of the bank management entities within its database. This describes the logical structure of the system’s database …
ER Diagram for Order Management System
The order management system ER Diagram reveals the relationships of its entities to form the project database design. This describes the logical structure of the system’s database or data storage. …
Shopping Cart ER Diagram | Entity Relationship Diagram
The ER diagram for online shopping cart project reveals the relationships of the shopping cart entities within the database. This describes the logical structure of the system’s database or data …
ER Diagram for Login Process | Entity Relationship Diagram
The ER diagram for user login process reveals the relationships of the login entities within the database. This describes the logical structure of the system’s database or data storage. It …
ER Diagram for Login and Registration Page
The ER diagram for registration and login reveals the relationships between the login and registration entity sets in a database. This displays the logical structure of databases. It is done …
ER Diagram for Face Recognition Attendance System
The Face Recognition Attendance System ER Diagram reveals the relationships between the system’s entity sets in a database. This displays the logical structure of databases. It is done by identifying …
ER Diagram for Course Registration System
This ER (Entity Relationship) Diagram shows how the Course Registration System ERD is set up. The entity-relationship diagram for the Course Registration System shows every visual representation of database tables …
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.