Google Answers Logo
View Question
 
Q: Database questions - about normalization ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Database questions - about normalization
Category: Computers > Software
Asked by: helloworld-ga
List Price: $10.00
Posted: 26 Jul 2003 02:08 PDT
Expires: 25 Aug 2003 02:08 PDT
Question ID: 235286
Is normalization more pratical as a part of a top-down or bottom-up
methodology? WHY?
Answer  
Subject: Re: Database questions - about normalization
Answered By: maniac-ga on 26 Jul 2003 17:48 PDT
Rated:5 out of 5 stars
 
Hello Helloworld,

Hmm. An interesting question because normalization of a database is
generally considerd a "bottom up" method.

Let's start with a brief definition of top down and bottom up methods.
 Using
  http://courses.mgmt.dal.ca/comm3516/Notes/Notes6.htm
as a reference (near the bottom):

Top down starts by defining the data sets and then define the data
elements within those sets. As a result of this method, you generally
end up with redundant information in one or more tables. Some
references call this Entity - Relationship modeling.

Bottom up starts by defining the required attributes and then grouping
them to form the entities. Another term used for this method is
normalization from functional dependencies.

A good reference that lists a number of attributes of both top down
and bottom up methods is
  http://www.cs.mu.oz.au/~yuan/Ingres/us_13264.html
that also includes an extensive reference list of publications.

Other references and more information can be found at

  http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/print_html
  A good - constructive example of the result of a top-down design and
the normalization of the result.

  http://www.hpdrc.fiu.edu/library/books/datades-book/chapters/chapter5.html
  Skip past the extensive example down to section 5.3 which starts
with a good discussion of normalization - characterizes it as a
"bottom up" method.

  http://www.shef.ac.uk/~rmn/shared/exercise/erd/erd-e2.htm
  http://www.shef.ac.uk/~rmn/shared/exercise/normalis/n-e2.htm
  Two pages that have examples of a simple application and how you
would generally approach them as "top down" vs. "bottom up".

Search phrases included:
  top down database normalization
  bottom up database normalization
  compare "top down" "bottom up" database

So, to answer your original question - normalization is a "bottom up"
methodology and is more "practical" as one. Please note that, a number
of sites also recommend a combination of top down and bottom up
methods when defining your data base.

  --Maniac
helloworld-ga rated this answer:5 out of 5 stars

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy