Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Normalization
Normalization is the way of removing redundant data from the database. Simply we can say that it is a process of organizing the columns and tables (relations) to reduce data redundancy.
1NF- According to the rule of 1NF an column of a table cannot contain more than one values. It should contain atomic values (single).
2NF-We can say a relation is in 2NF if it is in 1NF and no non-prime attribute is dependent .Non-prime is an attribute that is not a part of any candidate key.
3NF-We can say that a relation is in 3NF if it satisfies the two condition.
1-It should be in 2NF
2-All non-primary fields are dependent on the primary key.