RelationalDBDesign RelationalDBDesign



ER Diagrams   «Prev 

Identify Relationships between Database Tables

Entity-relationship (ER) diagrams (ERDs) provide a way to document the entities in a database along with the attributes that describe them. There are actually several styles of ER diagrams. Today there are three major methods:
  1. the Chen model (named after the originator of ER modeling, Dr. Peter P.S. Chen),
  2. Information Engineering (IE, or crows feet), and
  3. Unified Modeling Language (UML).
If you are not including object-oriented concepts in a data model, it really does not matter which you use, as long as everyone who is using the diagram understands the symbols. However, UML is specifically intended for the object-oriented environment and is usually the choice when objects are included.

Customer may place many orders (1:N)

and each order comes from a single customer.

Every project is assigned to a project manager

But a project manager may be assigned to no more than three projects (1:N)

A vendor supplies many products (1:N)

but each product comes from a single vendor.