Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Database design and normalisation ??


Dear all,

I am preparing my last exam for MCSD and actually I have a huge lack of
undertsanding on the best way to organise your dtabase based on buisness
requirement as well as normalization part.

Does anyone has a good link which explain this and guide lines from a
practclae case ?

I browse the BOL 2005 but no clear things occurs for me

thanks for help
regards
Serge

Serge,

Very big question.  Regarding normalization, there are many resources such
as:
http://support.microsoft.com/kb/283878
http://en.wikipedia.org/wiki/Database_normalization

Normalization to at least 3NF is an excellent starting point for physical
database design. This is essentially an exercise in implementing logical
sets.

The harder topics are 1) understanding the business rules, 2) understanding
the impact of 3NF on processes, and 3) determining when (rarely) to make
exceptions.

RLF

"calderara" <calder@discussions.microsoft.com> wrote in message

news:CFA6164D-7B19-47F2-84BC-CDF19C7C768C@microsoft.com...

Tha nks

This sis a big topic as you said, and quite hard for me to catch.
in this final exam a lto of quetsion on database design and nomralizazion or
many to many relation ...

I suffer.
serge

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc