What is Normalization ?
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
What is the quickest way to fetch the data from a table?
What is sharded cluster?
Explain rename?
Explain the difference between sql and oracle?
Why packages are used in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain oracle 12c new features for developers?
What is a cursor and what are the steps need to be taken?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is user managed backup in Oracle?
How do we represent comments in oracle?
What are named parameters?
Explain what are the characteristics of data files?
How to rename a column in an existing table?
What is Trigger in Oracle?