SysFEAT - Systemic Framework for Enterprise Architecture & Transformationk

BUILDING BLOCK - Relational Entity

Description	Abstract Concept A Relational Entity is a relational data structure that is either a Table or a Table View. A Relational Entity is accessible by means of a primary key, and if necessary foreign keys; it is described by an ordered sequence of Columns.
External references	DDD - Glossary - Entity
Super Types	Physical Data Entity Relational Data bLOCK
Functional Domain	Physical Data Domain
Dictionary	Dictionary of SysFEAT concepts
Lexical Scope	Architecture Container Data Dictionary Relational Dictionary
Framework Mapping	DoDAF Mapping : Physical Entity

RELATIONSHIPS

Simple Graph Graph & Inheritance Table

Simple Graph

Composition: ➝ Classification: ➝ Specialization: ➝ Enumerated definition: ➝ Syntax: ➝

Graph & Hierarchy

Composition: ➝ Classification: ➝ Specialization: ➝ Enumerated definition: ➝ Syntax: ➝

Relationship Table

Relationship	Cardinality	Target Entity	Source Entity	Description
Column	[*..0]	Column Type	Relational Entity	A Column is the basic component of a relational Relational Entity (Table or Table View). A Column is derived from the Attribute of a Logical Data Entity or an Association. It can be connected to the Index or the Key that it constitutes.
Specialized Physical Entity	[*..0]	Physical Data Entity	Physical Data Entity
Realized Data Asset	[*..0]	Data Asset	Physical Data Asset
Realized Concept	[*..0]	Domain Asset	Data Asset	Data Domains that the Data Asset is an implementation of.
Specialized Class of Bounded Individual	[*..0]	Class of Bounded Individual	Class of Bounded Individual
Qualification	[*..0]	Property	Class of Bounded Individual	A specialization from a Class of Bounded Individual to a Property that asserts all members of the Class of Bounded Individual have the Property.
Start Type	[*..0]	Temporal Bounding Type	Class of Bounded Individual
End Type	[*..0]	Temporal Bounding Type	Class of Bounded Individual
Temporal Sequencing Type	[*..0]	Temporal Bounding Type	Class of Bounded Individual
Realized Functional Asset	[*..0]	Functional Asset	Functional Asset	A kind of specialization between an implementing Functional Asset and its abstract Realized Functional Asset.Realization relationships are the foundation to establish the mapping between Functional Assets that belong to different Conceptualization Levels.
Policy Conformance	[*..0]	Policy	Functional Asset	A Policy Conformance is the conformity requirement that applies a Functional Asset.
Hierarchical Member	[*..0]	Building Block	Aggregate Block	A Hierarchical Member is an Aggregate Member that is also a Block Lexical Scope for the Building Block it aggregates: it relates its aggregated block by nesting (see Nesting Relationship).Hierarchical Members are used to build hierarchical structures of Building Blocks, in constrast to Block Members which are used to build network structures of Building Blocks.
Block Member	[*..0]	Building Block	Aggregate Block	A Block Member is an Aggregate Member that aggregates its releated Building Block by reference (see Referencing Relationship).Block Members are used to build network structures of Building Blocks while Hierarchical Members are used to build hierarchical structures of Building Blocks.

TEXTUAL SYNTAX

SEMANTIC TAXONOMY

Sub-Types Super-Types

Click node rectangle to collapse/expand one level. Click triangle for full recursive collapse/expand. Double-click on a node to open its URL. Hover for description.

INTERNAL STRUCTURE

../images/362f3ca45b3b234b_e6f22cde5f771f3d_i.png

BUILDING BLOCK - Relational Entity

RELATIONSHIPS

Simple Graph

Graph & Hierarchy

Relationship Table

TEXTUAL SYNTAX

SEMANTIC TAXONOMY

INTERNAL STRUCTURE

CHARTER

Missing Content

Governance

Provide Feedback