Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the concept of normalization.

Answer Posted / nashiinformaticssolutions

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is duration in sql profiler trace?

1066


What are the key differences between SQL and PL SQL?

1202


What are all the common sql functions?

1002


What is primary key in db?

993


How do you write a complex sql query?

1045


What are sql*plus environment variables?

1077


What is scalar data type in pl sql?

1055


What is cursor and why it is required?

1169


What is before and after trigger?

936


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1428


What are the sql commands?

1142


Are stored procedures faster than queries?

930


Is mariadb a nosql database?

1038


What is basic structure of pl sql?

1054


What does partition by mean in sql?

949