| Associative Entity |
An entity that exists to create a relationship between two other entities. |
| Attribute |
A characteristic or property of an entity. |
| Cardinality |
Describes the number of instances of one entity that are associated with the number of instances of another entity. |
| Conceptual ERD |
A high-level diagram that depicts the important entities and their relationships in a database |
| Entity |
An object or concept about which data is stored in a database. |
| Entity Relationship Diagram (ERD) |
A visual representation of the logical structure of a database, showing the relationships between entities |
| Foreign Key |
An attribute that references the primary key of another table, establishing a relationship |
| Junction Table |
A table in a relational database that serves as a link between two other tables by containing foreign keys from each table. |
| Logical ERD |
A detailed diagram that includes attributes and primary keys for each entity in a database |
| Many-To-Many Relationship |
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. |
| Physical ERD |
A diagram that shows the implementation details of a database, including data types and constraints |
| Primary Key |
An attribute or set of attributes that uniquely identifies each record in a database table |
| Relationship |
Describes how entities are related to each other in a database. |
