BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

1064Entities and attributes
1065Entity-relationship diagrams
1066Crow's foot notation
1067Cardinality and participation
1068One-to-one relationships
1069One-to-many relationships
1070Many-to-many relationships
1071Junction tables
1072Weak entities
1073Recursive relationships
1074Supertypes and subtypes
1075Single-table inheritance
1076Class-table inheritance
1077Concrete-table inheritance
1078Polymorphic associations
1079Temporal modeling
1080Slowly changing history tables
1081Audit trail tables
1082Soft delete modeling
1083Naming conventions
1084Reserved words and identifier choices
1085Choosing surrogate keys
1086Update anomalies
1087Insertion anomalies
1088Deletion anomalies
1089Functional dependencies
1090Armstrong's axioms
1091Attribute closure
1092Candidate key discovery
1093First normal form
1094Second normal form
1095Third normal form
1096Boyce-Codd normal form
1097Multivalued dependencies
1098Fourth normal form
1099Join dependencies
1100Fifth normal form
1101Sixth normal form for temporal data
1102Lossless decomposition
1103Dependency preservation
1104Minimal cover
1105Denormalization trade-offs
1106Redundancy with summary tables
1107Star-like denormalization
1108EAV anti-pattern
1109JSON columns versus normalized tables
1110Blog platform schema
1111Comment threads schema
1112Tagging schema
1113E-commerce catalog schema
1114Product variants schema
1115Shopping cart schema
1116Order lifecycle schema
1117Inventory ledger schema
1118Payment and refund schema
1119SaaS multi-tenant schema
1120Role-based access schema
1121Subscription billing schema
1122Audit logging schema
1123Social graph schema
1124Messaging schema
1125Booking and availability schema
1126Ride-sharing schema
1127Library lending schema
1128Analytics event schema
1129Learning management schema
1130Healthcare appointment schema
1131Banking double-entry ledger
1132Geospatial places schema
1133Feature flags schema

Databases & SQL

1064Entities and attributes
1065Entity-relationship diagrams
1066Crow's foot notation
1067Cardinality and participation
1068One-to-one relationships
1069One-to-many relationships
1070Many-to-many relationships
1071Junction tables
1072Weak entities
1073Recursive relationships
1074Supertypes and subtypes
1075Single-table inheritance
1076Class-table inheritance
1077Concrete-table inheritance
1078Polymorphic associations
1079Temporal modeling
1080Slowly changing history tables
1081Audit trail tables
1082Soft delete modeling
1083Naming conventions
1084Reserved words and identifier choices
1085Choosing surrogate keys
1086Update anomalies
1087Insertion anomalies
1088Deletion anomalies
1089Functional dependencies
1090Armstrong's axioms
1091Attribute closure
1092Candidate key discovery
1093First normal form
1094Second normal form
1095Third normal form
1096Boyce-Codd normal form
1097Multivalued dependencies
1098Fourth normal form
1099Join dependencies
1100Fifth normal form
1101Sixth normal form for temporal data
1102Lossless decomposition
1103Dependency preservation
1104Minimal cover
1105Denormalization trade-offs
1106Redundancy with summary tables
1107Star-like denormalization
1108EAV anti-pattern
1109JSON columns versus normalized tables
1110Blog platform schema
1111Comment threads schema
1112Tagging schema
1113E-commerce catalog schema
1114Product variants schema
1115Shopping cart schema
1116Order lifecycle schema
1117Inventory ledger schema
1118Payment and refund schema
1119SaaS multi-tenant schema
1120Role-based access schema
1121Subscription billing schema
1122Audit logging schema
1123Social graph schema
1124Messaging schema
1125Booking and availability schema
1126Ride-sharing schema
1127Library lending schema
1128Analytics event schema
1129Learning management schema
1130Healthcare appointment schema
1131Banking double-entry ledger
1132Geospatial places schema
1133Feature flags schema

← Databases & SQL

Search the Databases & SQL glossary

Lesson 1102 of 2,478·15. Modeling and NormalizationFree lesson

Lossless decomposition

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy