Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Understand Database Normalization (1NF, 2NF, 3NF)

- 24.06.26 - ErcanOPAK

📊 Normalization = Organized Data

Bad design = duplicate data, anomalies. Normalization organizes data. 1NF, 2NF, 3NF — reduce redundancy, improve integrity.

📝 First Normal Form (1NF)

❌ Not 1NF (repeating groups)
Order: 1, Customer: Alice, Products: Laptop, Phone, Tablet

✅ 1NF (atomic values, separate rows)
OrderID  Customer  Product
1        Alice     Laptop
1        Alice     Phone
1        Alice     Tablet

✅ 1NF: Each cell has single value
✅ 1NF: Each row is unique

🎯 Second and Third Normal Form

✅ 2NF: In 1NF + all non-key columns depend on entire primary key
(For tables with composite keys)

❌ 2NF violation:
OrderID  ProductID  ProductName  Price
1        101        Laptop       999
1        102        Phone        599

✅ 2NF fix (split tables):
Orders: OrderID, Customer
OrderItems: OrderID, ProductID
Products: ProductID, ProductName, Price

✅ 3NF: In 2NF + no transitive dependency
❌ 3NF violation:
EmployeeID  Department  DepartmentHead
1           IT          John
2           Sales       Mary

✅ 3NF fix (split tables):
Employees: EmployeeID, DepartmentID
Departments: DepartmentID, DepartmentName, DepartmentHead

💡 Benefits

  • Reduces data redundancy
  • Prevents anomalies (insert, update, delete)
  • Improves data integrity
  • Easier maintenance
  • Better performance (with proper indexes)

“Normalization eliminated duplicate data. Update anomalies gone. Essential database design.”

— Database Designer

Related posts:

SQL Tip: NOCOUNT should be activated on PROCEDURE and TRIGGER definitions

SQL Tip: "NOCOUNT" should be activated on "PROCEDURE" and "TRIGGER" definitions

SQL — Floating Point Columns Corrupt Financial Data

SQL — Floating Point Columns Corrupt Financial Data

SQL Server: Recover a Dropped Table in Seconds Before the Space Gets Reused

SQL Server: Recover a Dropped Table in Seconds Before the Space Gets Reused

Views: 11

Post navigation

.NET Core: Use API Controllers for RESTful Services
C#: Use Extension Methods to Extend Existing Types

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com