- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Environmental Science
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is Normalization in SQL ?
Normalization is used to decompose a larger, complex table into simple and smaller ones. This helps us in removing all the redundant data.
Generally, in a table, we will have a lot of redundant information which is not required, so it is better to divide this complex table into multiple smaller tables which contains only unique information.
First normal form:
A relation schema is in 1NF, if and only if :
– All attributes in the relation are atomic(indivisible value)
– And there are no repeating elements or group of elements.
Second normal form:
A relation is said to be in 2NF, if and only if:
It is in 1st Normal Form.
No partial dependency exists between non-key attributes and key attributes.
Third Normal form:
• A relation R is said to be in 3NF if and only if:
It is in 2NF.
No transitive dependency exists between non-key attributes and key attributes through another non-key attribute
- Related Questions & Answers
- What is a trigger in SQL ?
- What are Nested Triggers ?
- What are the types of SQL Queries ?
- What is SQL ?
- How to insert date in SQL ?
- How can I see all tables in SQL?
- What is OLTP ?
- What is PL/SQL ?
- How to create a database in SQL?
- How to delete a column in SQL ?
- How to delete a row in SQL ?
- What is join in SQL ?
- How to find the nth highest salary in SQL ?
- What is Normalization in SQL ?
- How to insert multiple rows in SQL ?
- What is SQL injection ?
ads