Logical Data Modeling - Business Key

Data System Architecture


A business key is a key that use the business users to identify uniquely an entity. It's then also a unique key.

The business key is a meaningful/business code based generally on the concatenation of attributes value of an entity instance.

It's used generally in datawarehouse next to a surrogate key in order to create item that were not found for instance

Discover More
Data System Architecture
Logical Data Modeling - Key

A key refers to a attribute, or a group of attributes, which assumes a unique value for: each entity in a entity set. or relationship in a relationship set. keyidentifier... database primary...
Data System Architecture
Surrogate (Sequence, GUID) vs Natural key (Business Key)

What's the best choice of data for your primary key ?
Data System Architecture
What is a Surrogate Primary key? known also as Substitute, Synthetic or Generated Key - Logical Data Modeling -

A surrogate key is a substitute primary key for when: the data entity are created in distributed way you don't have access to a central entity such as database to create a simple sequence you don't...

Share this page:
Follow us:
Task Runner