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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What is Normalization ?

Question Posted / ron

Answer Posted / ron

Note:
1. data is normalized in oltp systems
( are of different forms :1NF, 2NF, 3NF, BCNF, 4NF,
5NF,DKNF,6NF)
2. when it comes to olap/datawarehouse/dss sytems data is
generally de-normalized. (N1NF, PNF).

there is always a trade-off to consider between data
redundancy vs performance

Is This Answer Correct ?    37 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we convert a date to char in oracle and if so, what would be the syntax?

1013

Explain the use of rows option in exp command.

1088

What is different types of joins?

1018

How to recover a dropped table in oracle?

1042

What is a read write transaction in oracle?

1088

Explain the use of ignore option in imp command.

1035

What is oracle and what are its different editions?

1064

What is the relation of a user account and a schema?

1130

Why we use bulk collect in oracle?

1042

What is a nvl function?

1021

What are the limitations of check constraint?

1028

How to use "for" statements in oracle?

1072

How to speed up webrick?

1074

How to rename an existing table?

1125

How many types of table in Oracle?

1119