Logical Data Modeling - Duplicate

Data System Architecture


A duplicate happens when in a set two elements have an equivalence relationship that returns true.


  • In the set {1,1,2,3}, 1 is a duplicate
  • The set {1,2,3} has no duplicate

Data Processing Operation

relational operators can create duplicates but no all.

See below:

Operator Symbol Creates Duplicates?
Selection σ No
Projection π Yes
Cross-product × No
Set-difference No
Union Yes
Join No

Discover More
Data System Architecture
Logical Data Modeling - Entity Integrity (Uniqueness|No Duplicate|Distinct)

Entity integrity concerns the concept of uniqueness (also called no duplicate) Uniqueness is enforced with: primary key unique key (on a column or indice) Entity integrity is an integrity rule...
Thomas Bayes
Mathematics - Combination (Binomial coefficient|n choose k)

A combination is a selection of elements from a set where the order of selection does not matter. Order doesn't matter means that the selections AB and BA are considered a single combination (a single...

Share this page:
Follow us:
Task Runner