Entity Relationship
Attribute Cardinality
Associative Entity Junction Table
Many-To-Many Relationship Entity Relationship Diagram (ERD)

 

Describes how entities are related to each other in a database. An object or concept about which data is stored in a database.
Describes the number of instances of one entity that are associated with the number of instances of another entity. A characteristic or property of an entity.
A table in a relational database that serves as a link between two other tables by containing foreign keys from each table. An entity that exists to create a relationship between two other entities.
A visual representation of the logical structure of a database, showing the relationships between entities A type of relationship between two entities where each record in one table can be related to many records in another table, and vice versa, necessitating a junction table.

 

Conceptual ERD Logical ERD
Physical ERD Primary Key
Foreign Key

 

A detailed diagram that includes attributes and primary keys for each entity in a database A high-level diagram that depicts the important entities and their relationships in a database
An attribute or set of attributes that uniquely identifies each record in a database table A diagram that shows the implementation details of a database, including data types and constraints
An attribute that references the primary key of another table, establishing a relationship