Normalization is a Systematic Approach, which is used to design a Relational Database table up to higher normal form. The basic goal of normalization is to keep each attribute in …
Data Modeling – De-Normalization and Canonical Model
De-Normalization is the deliberate transformation of normalized logical data model entities into physical tables with redundant or duplicate data structures. In other words, de-normalization intentionally puts one attribute in multiple …
Content Management – Terms Management
As per DAMA, Lists of terms are just that: lists. They do not describe relationships between the terms. Pick lists, web pull-down lists, and lists of menu choices in information …
Benefits of Online Education
The use of Online Education has increased immensely. Given the situation, it has become popular all over the world. Students are finding it much helpful due to its easy accessibility. …
Why choose Virtual Learning?
Virtual Learning is one of the sectors, which is increasing day by day. Some of its major advantages includes flexibility in managing time as well as learning pace. All you …
Data Modeling – Identifiers / Keys
Key or Identifier, is a set of one or more attributes that uniquely defines an instance of an entity. Keys by Construction-Type Surrogate Key is a unique identifier for a …
Content Modeling – Controlled Vocabularies and Format
Controlled Vocabularies The primary purpose of Vocabulary Control is to achieve consistency in the description of content objects and to facilitate retrieval. A Controlled Vocabulary is a pre-defined, established and …
Data Modeling – Arity of Relationships
Arity of RelationshipsThe number of entities in a relationship is the Arity of the relationship. The most common Arities are unary, binary, and ternary relationships. Unary (Recursive) Relationship: A unary …
Data Masking – Data Subsetting
Data Masking is the process to replace, truncate, scramble, or encrypt sensitive data with fictitious yet realistic looking. Data Masking limits sensitive data proliferation by anonymizing sensitive production data. Data …