NULLS — The Original Sin of Database

Data Modeling for Handlings NULLs

Gaurav Goel
Geek Culture
Published in
4 min readJan 18, 2023

--

Photo by Ben Hershey on Unsplash

NULL value represents unknown or missing data for an attribute. A table containing many attributes (columns) with NULL values may indicate a poor database design. Unknown values become a pain while querying the database for specific business scenarios. Some of the situations where NULL values can cause problems are:

--

--

Gaurav Goel
Geek Culture

Storyteller, learner, thinker and a Software Professional dealing with Science and Engineering of Data