The Entity/Association model: Basic Concepts
Definition :
The Entity-Relationship (E/R) model is a fundamental framework in database design, used to represent real-world data and its structure. At its core, the model is built around the concept of an entity, which refers to any distinguishable object or thing in the domain being modeled. Each entity is described by a set of properties (also called attributes) that define its characteristics. An occurrence of an entity corresponds to a specific instance of that entity, containing actual data for its properties. To uniquely identify each occurrence, an identifier (or key) is assigned. Relationships (or associations) are used to illustrate how entities interact with each other, and each relationship is characterized by its cardinality, which defines the number of entity occurrences that can participate in the relationship. This model provides a clear and structured way to visualize and design database systems.
