Normalization as Single-Theme Paragraph Reorganisation

Discipline

Databases

Form

Database Analogies

Attribution — Origin / Source

Collected by Yuhan Pan — Kroenke, D., & Auer, D. (2016). Database Processing Fundamentals, Design, and Implementation. 14 ed. Pearson.

Topic

Design theory and normalization

Domain

Anything else

Conceptual Advantage

reduce data redundancy and eliminate modification anomalies, by relating it to a familiar concept from English grammar

Mapping

SymbolConcept
Database Table Paragraph
Data "Themes" Paragraph Themes
Normalisation Reorganising/Breaking up paragraphs

Draws Attention To

highlights the design principle of decomposition

Details

Text

Do you remember your eighth-grade English teacher? She said that every paragraph should have a single theme. If you write a paragraph that has two themes, you should break it up into two paragraphs, each with a single theme.

Comments or Feedback?

Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.

For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".

Create an Issue on GitHub