what is difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.
- 3 Answers
- 24674 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / Amit Tripathi
Normalization and denormalization are opposite database design concepts. Normalization aims to reduce data redundancy by organizing tables in a way that minimizes duplicate information and promotes data integrity. In normalized form, each table contains atomic data without any repeating groups or sub-tables. Denormalization, on the other hand, involves duplicating data across multiple tables to improve query performance at the cost of increased redundancy. Normalized databases are not always in normal form (e.g., first normal form, second normal form, third normal form, etc.).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is your team size
please send me ubi model papers to my email idsssss anil0001_mca@yahoo.co.in , ravi_kumar3713@yahoo.com thankuuuuuuu
I Need Apsrtc Traffic Supervisor Medal Paper.. Please send me any one.....gasiganti@gmail.com
tell me abt ur most memorable moment
which companies in nifty
* i completed gratuation BBA but i passed 50% marks and i will give bank exam its valiad for bank
IS ANYONE FROM GUJARAT RECEIVED JOINING LETTER OF BOB CLERK 2011 , KINDLY POST IT or CONTACT BY EMAIL. sinhasanjiv73@gmail.com
why DEPB Licence application is doing
why u have choosen finance has a specialisation
