A database diagram clearly details the structure, relationships, and data rules in a database. It makes storing, retrieving and manipulating your data much simpler by ensuring your data’s consistency and organisation.
This image belows shows a very simple database diagram containing four entities, three of them are linked through 1:many or 1:1 relationships, and the fourth is standalone.
Each entity has it’s own list of fields, alongside their associated data types. A database diagram identifies the following:
Entities – In a database, these are your tables. They represent the core components of your Data. In this example, we have