Logical Data Modeling - Id attribute

Data System Architecture


An id is an label attribute with a numeric representation that identify uniquely an entity or a relationship in a local scope.

versus the name attribute which is the textual counterpart representation

If the id attribute is chosen as the local identifier, it will be:



If there is no namespace functionality that describe the identifier, the id of an entity describe its identity. <MATH> \Large id+entity = identity </MATH>


See How to protect numerical Id ? (obfuscate, id encryption)

Discover More
Alter Table Railroad Sqlite
How to alter a table structure with SQLite?

The alter statement of SQLite is pretty limited. This page shows you: what you can do and can't do with an alter table statement how to modify the structure of your table You can: rename a table...
Sqlite Banner
How to create or add a Primary Key to a Sqlite Table

This article shows you how to add, create or modify a SQL primary key constraint The following schemas are logically equivalent because the primary keys are implemented by creating a unique index...
Data System Architecture
How to protect numerical Id ? (obfuscate, id encryption)

This page is how to obfuscate / protect a internal id. So that even if they are public, they cannot be guessed. This is mostly used to prevent guessing your data. For instance, you can estimate...
Data System Architecture
Logical Data Modeling - Classifier (Label, Class, Tag) - Descriptif Attribute

A label is an attribute that describes its entity or relationship with nominal data. A label is also known as: a tag a class or just a nominal attribute a classifier a group a category Classifiers...
Data System Architecture
Logical Data Modeling - Global Identifier (Fully Qualified Name, Canonical Form)

A global identifier identify uniquely a primary element (entity or relationship) in the global scope It's also generally known as: the fully qualified id the fully qualified name the canonical...
Data System Architecture
Logical Data Modeling - Primary Key (Id, Name)

A Primary Key is a key that identify indefinitely uniquely an element: entity or a in their local scope. It's a part of the fully qualified identifier. A real primary key is immutable as...
Undraw File Manager Re Ms29
What is a relative path ?

A relative path is a path that does not start with a root (prefix) It is relative to another path that is unknown. You need to transform it as absolute|absolute path before accessing any file. Below...
Undraw File Manager Re Ms29
What is an absolute path ?

A path is absolute when it starts with a root (prefix). It contains all the information needed to locate the file. Inside a file system, the absolute path is the file identifier. Absolute path: This...

Share this page:
Follow us:
Task Runner