Which is normalization is best when we performing database design?

  • Hi Friends,

    I need some help to understand normalization. Could anybody please tell me which normal form is used currently for database design for big application.

    Thanks & Regards,

    P.Prakash.

  • at least go for 3th or 4th NF to understand the data and its relationships.

    Stick with that as long as you can. (i.e. unless it is proven to be less performing than expected)

    It will bring the best adaptability during your project and afterward.

    If you are really forced to denormalize, do it properly ! don't just dissolve the small entities to a big one, but keep the original key values to ease opdate of these parameters.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Thank You ALZDBA

    Regards

    P.Prakash

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply