Entity Relationship Diagram

Entity Relationship Diagram (ERD), a database design tool that provides graphical representation of database tables, their columns and inter-relationships. ERD is the most popular database design tool.

Online Photo Album

This is a ER Diagram example that shows the database design of the Online Photo Album. Database view is a…

Movie Rental

This ERD example model represents business entities of a DVD rental store using detailed physical ERD (for designing database schema…

Inventory System

The ERD example models the following scenario: A salesperson may manage many other salespeople. A salesperson is managed by only…

Video Rental System

This ERD example shows a very simple database design of a video rental system by describing the customer, movies and…

Production Tracking

Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, children’s toys, etc.). The following ER diagram example…

UPS System

UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this,…

Small Loan System

This is a simple ERD example for loan system. Micro loans are small loans, which is beginning to gain popularity…

Research Cooperation and Exchange

The academic world is an interesting example of international cooperation and exchange. This ERD example is concerned with modeling of…

Simple Order System

This ERD example models a simple order system with the following entities: Customer: stores customer’s data. Product: stores a list…

College

This ERD example shows the typical business entities of a college. A college contains many departments which can offer any…