The ER Diagram reveals the overall structure of the database's entities and attributes. The syntax for the ER diagram symbols is as follows:

• "Square" = Entities
  
• "Circle" = Attributes
  
• "Double-Line" and "Circled-D" = Disjointed. Has to be one or the other.
  
  

The Relational Schema reveals the relationships between the aforementioned entities and attributes. The syntax for the symbols are as follows:

• "Underline" = Primary Key
  
• "Arrow" = Primary Key/Foreign Key relationship.
  
  

The Functional Dependences reveal how some entities and attributes are dependent upon the other, and how an attribute can be obtained via traversing other attributes present in different entities.