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...

What is normalization and types of normalization?

Answer Posted / r.arjunarao

Normalization means reduces redundancy unnecessary
repetition of data is NF
UnNormalization means intentional introduction redundancy to
a table to improve the performance is De-NF or Un-NF
1NF Any multiple values Attribute have been removed.
2NF Any partial functionality dependency have been removed.
3NF Any transitive functionality dependency have been removed.
4NF Any multi-values dependency have been removed.
5NF Any remaing anomalies have been removed.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to use transactions efficiently : transact sql

990


What does sql stand for?

1003


what is the difference between sql and t-sql? : Transact sql

1100


What does the acronym acid stand for in database management?

1046


What is sqlerrd?

972


What is pivot table in sql?

1116


Which is the correct statement about truncate and delete?

1121


what are the advantages a stored procedure? : Sql dba

986


how many values can the set function of mysql take? : Sql dba

999


Are pl sql variables case sensitive?

1056


what is the use of double ampersand (&&) in sql queries?

1184


Explain the purpose of %type and %rowtype data types with the example?

1002


What is composite primary key in sql?

1006


What is coalesce sql?

1010


What are the key differences between SQL and PL SQL?

1227