Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    9

    ERD and Normalisation

    When i design databases for uni cworks i tend to design my ERD and then attempt to normalise but the design is normally always in 3rd normal form. Is this because the problems are trivial and not that difficult or is it that i'm making mistakes with my method of designing.

    My understanding is that normalisation is a technique for spotting mistakes in the design stages?

    This is always a problem when trying to produce documentation to support c works in that the normalisation section is always of limited contents.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Don't worry - this just means that you are naturally good at database design! Normalisation is really just formalised common sense, so a good database designer tends to get it right first time without any formal normalisation stage.

    If that causes a problem with your class work, then I guess you'll just have to purposely denormalise your ERD a bit first!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •