If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > ERD and Normalisation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-03-05, 15:04
cwil2 cwil2 is offline
Registered User
 
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.
Reply With Quote
  #2 (permalink)  
Old 01-03-05, 16:41
andrewst andrewst is offline
Moderator.
 
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!
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On