normalization

Question

my question is when large number of tables is created in database.....then it will load on server...so is it possible to breaking load when application is acess..

and normalization can help to breaking load data on server....

plz sugest me what shuld i do?

Upamanyu Roy Choudhury · Answer

Hi Vikas, Normalisation is the process of reducing or minimising data redundancy. So when we break a single table which say in 0NF then convert it upto say 3NF and reduce redundancy then we are breaking up tables from a single one. But we also need to keep in mind so that database objects must be kept in such a number which should not put pressure in the database. So we often inject redundancy in order to keep a tab on this. Thus the idea is to select an optimised way to tackle the redundancy not in the cost of performance overhead. Get a few concepets in 0NF,1NF,2NF,3NF,4NF,5NF,BCNF etc and keep one thing in mind we tend to do something different in large projects and we cannot just follow strict rules of database everytime. Keep me posted

Upamanyu Roy Choudhury · Answer

Hi Vikas, Normalisation is the process of reducing or minimising data redundancy. So when we break a single table which say in 0NF then convert it upto say 3NF and reduce redundancy then we are breaking up tables from a single one. But we also need to keep in mind so that database objects must be kept in such a number which should not put pressure in the database. So we often inject redundancy in order to keep a tab on this. Thus the idea is to select an optimised way to tackle the redundancy not in the cost of performance overhead. Get a few concepets in 0NF,1NF,2NF,3NF,4NF,5NF,BCNF etc and keep one thing in mind we tend to do something different in large projects and we cannot just follow strict rules of database everytime. Keep me posted

normalization

Answers (2)