Normalization

As explained in Building Web APIs with ASP.NET Core

Normalization is the organization of relational data into structured tables to reduce redundancy and preserve data integrity.

Normalization organizes relational data into fixed, related tables so each record is identified clearly and repeated information is reduced. This structure can preserve integrity, but it may require a more complex schema than a document-oriented design. section 4.1.1

A normalized SQL design typically uses:

• Primary keys that uniquely identify records in each table. section 4.1.1
• Reference columns, such as BoardGameID in Comments, to connect related records. section 4.1.1
• Separate tables and junction tables for relationships such as BoardGames, Domains, and Mechanics. section 4.1.1

Figure 4.1 MyBGList database schema diagram for a table-oriented SQL database

Use the relational schema diagram to see how normalized tables and junction tables divide the board-game data. section 4.1.1

How Building Web APIs with ASP.NET Core covers it

How deep it goes

Explains primary keys, reference columns, fixed schemas, and junction tables, but stops short of normalization forms or procedural rules.

Examples

Uses BoardGames, Comments, Domains, Mechanics, and junction tables as concrete schema examples.

What you can do after

Evaluate whether related data belongs in normalized tables or embedded documents for a given application design.

How it connects

Connects normalization with primary keys, relational databases, fixed schemas, many-to-many relationships, denormalization, and NoSQL databases.

liveBookmanning.com

Read Building Web APIs with ASP.NET Core on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  Grokking Machine LearningA mathematical operation that rescales nonnegative quantities by their sum so that the resulting quantities sum to one.
• 

  liveBookmanning.com
  How Large Language Models WorkText normalization is the transformation of text into a standardized representation, such as by harmonizing character case or encoding.
• 

  liveBookmanning.com
  Classic Computer Science Problems in Swift: Essential techniques for practicing programmers
• 

  liveBookmanning.com
  Deep Learning with Python, Third EditionThe process of rescaling or normalizing features so they have more stable numerical properties for learning.
• 

  liveBookmanning.com
  AI-Powered SearchNormalization is the transformation of numerical features to a comparable scale, often by centering and scaling them according to their mean and standard deviation.
• 

  liveBookmanning.com
  The Quick Python Book, Fourth EditionNormalization is the process of converting data into a consistent canonical representation.
• 

  liveBookmanning.com
  Deep Learning with PyTorch, Second Edition
• 

  liveBookmanning.com
  Inside AINormalization is the transformation of numeric values to a specified bounded range so that they can be processed consistently by a model.
• 

  liveBookmanning.com
  LLMs in ProductionNormalization is the transformation of data values to a common scale or standardized representation.
• 

  liveBookmanning.com
  Delivering Machine Learning Projects: From design to deploymentNormalization is the transformation of data values into a consistent scale, unit, or representation so that they can be compared or combined appropriately.
• 

  liveBookmanning.com
  Generative AI in ActionNormalization is the transformation of data into a consistent scale, representation, or format.
• 

  liveBookmanning.com
  The Complete Obsolete Guide to Generative AIData normalization is the transformation of values to a comparable scale or representation so differences among variables can be meaningfully visualized or analyzed.
• 

  liveBookmanning.com
  Modern CNormalization is the process of reducing a rational representation so its numerator and denominator have no unnecessary common factors.
• 

  liveBookmanning.com
  Pandas Workout: 200 exercises to make you a stronger data analystNormalization is the organization of data into separate related structures so that each piece of information is stored only once.
• 

  liveBookmanning.com
  Data Without LabelsNormalization is the transformation of data values into a common representation or scale so variables can be compared.
• 

  liveBookmanning.com
  Modern C, Third EditionNormalization is the process of choosing a canonical representation of a rational number by reducing common factors from its numerator and denominator.
• 

  liveBookmanning.com
  Grokking Relational Database DesignNormalization is the process of organizing relational data into separate tables to reduce redundancy and prevent update anomalies.
• 

  liveBookmanning.com
  Grokking AI Algorithms, Second EditionNormalization is the standardization of textual representation, including characters, casing, whitespace, and related formatting.
• 

  liveBookmanning.com
  Microsoft Azure in ActionNormalization is the organization of relational data into related structures to minimize redundancy and maintain each fact in one place.
• 

  liveBookmanning.com
  Machine Learning System DesignThe transformation of numeric data so that its values conform to a specified scale or distribution.

Compare how 21 books explain normalization →

Related concepts

• lexemeproduces · A lexeme is a normalized linguistic term produced from text for representation and matching in full-text search.
• denormalizationcontrasts with · Denormalization is the deliberate combination or duplication of related data to simplify access, support particular access patterns, or improve performance.
• redundancyaddresses · Redundancy is the presence of duplicate or overlapping information, components, or resources, whether intentional or unnecessary.
• stemminguses · Stemming is a text-normalization technique that heuristically reduces inflected or derived word forms to a shared stem, which may not be a valid word.
• min-max normalizationincludes · Min-max normalization is a feature-scaling technique that linearly maps numerical values to a specified interval using their minimum and maximum values.

This explainer was generated by Manning's knowledge graph from the text of Building Web APIs with ASP.NET Core. The section links point to the parts of the book it draws on.