Oracle entity relationship diagram

A diagram showing the relationship of the entities in an Oracle database.

In the ERD, the #, *, and o symbols each has a specific meaning:
  • # means a primary key
  • * means that a value cannot be null
  • o means that a value can be null
Figure 1. Oracle Entity Relationship Diagram (ERD)
The diagram shows the possible structure of an Oracle schema.