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

How can I see all tables in sql?

1009


How do you select unique values in sql?

958


What is pl sql block structure?

986


what are the properties and different types of sub-queries? : Sql dba

986


What are procedures used for?

936


What is primary key secondary key alternate key candidate key?

995


Why stored procedure is faster than query?

983


Why primary key is required?

955


What is lexical units in pl sql?

1072


What are the types of operators available in sql?

1022


What are the 3 types of behavioral triggers?

1201


how to return query output in html format? : Sql dba

1035


How to run sql statements through the web interface?

999


How delete all data from all tables in sql?

902


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

978