7 terms
Cardinality in data modeling defines how many instances of one entity can relate to instances of another, such as one-to-many or many-to-many.
In data modeling, an entity is a distinct thing an organization needs to store data about, such as a customer or order, described by attributes and…
An ER diagram is a visual data model that shows the entities of a domain, their attributes and the relationships and cardinalities that connect them.
A many-to-many relationship links records where each entity can relate to many of the other, usually modeled with a junction table.
Normalization is the data modeling process of splitting relational tables so each fact is stored once, removing redundancy and update anomalies.
A one-to-many relationship in data modeling links one record in a parent table to any number of records in a child table through a foreign key.
A star schema is a data modeling pattern that places one central fact table of measurements among denormalized dimension tables for fast analysis.