Entity Relationship Diagrams

The final thing I want to discuss is databases. By the way, welcome to all second years who are now joining us.

As you are very well aware, the most important component of a well-designed information system is a well-designed database. While I am not going to go through how to design a database, we still need to be on the page when putting the design down on paper.

Take Note

This notation is not part of UML. ERDs are completely separate and stand-alone.

As with classes, databases consist of two main components:

  • Entities (the tables), and
  • Relationships between the entities.

Though there are multiple model types for databases, we will use the physical model. In most cases, your classes can translate directly to entities, but be careful not to assume that this is always the case.

Take Note

This notation only applies to relational databases. For noSQL-type databases, please consult your mentor.