Logical Data Modeling - Unique Key

Data System Architecture

About

A Unique Key identifies:

A primary key is also a unique key

The set of all unique keys defines the atomic level of the data.

Implementation

See Index - Unique Index





Discover More
Star Schema
Dimensional Data Modeling - Fact Table

A fact table is a table that stores fact where a fact can be seen as the representation of an event. It's also known as: Transactional history Unalterable fact. (The content of this kind of table...
Star Schema
Dimensional Data Modeling - Grain

The grain is the combination of all lower hierarchy level of the descriptif attribute of a relation (table or query). If you query only a table, the unique key of this table is the grain If you query...



Share this page:
Follow us:
Task Runner