answersLogoWhite

0

Hi,

Normalisation is used to reduce the redundancy of database. So, we divide the the data into smaller tables. These tables are related to each other through a relationship.
Denormalisation is the reverse process of normalisation. In this we add redundancy of data and grouping of data to optimize the performance.
User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is de-normalisation in dbms?

Hi, Denormalisation is the process to read the performance by adding redundancy of data or by grouping of data.


What is denormalisation?

The process of taking a normalised schema and making it nonnormalised is called denormalisation


What are the role of normalisation in dbms?

with this normalisation only we reduce redudency


What are the disadvantages of normalisation?

When we use Normalisation it does not allow some of the modifications of the database. Another disadvantage of Normalisation is that it is only applicable in the Relational Database Management System.


What normalisation is used in IEEE 754 format?

none, it uses denormalization.


Why is normalisation necessary?

Normalisation is necessary in database because of following:It eliminates data redundancy. Same data do not occur in more than one places.By making use of normalisation query process is easy.Data entry time is saved as the tables are broken down in repeating and not repeating fields.Data modification is made easy.Database becomes more flexibleInconsistent dependency is eliminated


What grade is 114 out of 185?

It is approx 62%. As to the grade, the answer will depend on any normalisation and grade boundaries.


What is difference between as on and as at?

difference between as on and as at


What grade would you make if for missing one out of 15?

You would get 93.3%. The grade might well depend on normalisation.


What are the differences between California and Florida?

What is the difference between Florida and California What is the difference between Florida and California


What is the difference between physician and doctor?

what's the difference between physician and doctorwhat's the difference between physician and doctor what's the difference between physician and doctor


What difference between paging?

Difference between paging and what?