Top Down Vs Bottom Up - Normalisation

database-design database-normalization bottom-up topdown top-down
user559142 picture user559142 · Apr 24, 2011 · Viewed 10.5k times · Source

Could someone describe for me the differences between top down normalisation and bottom up normalisation with regards to databases, namely relational databases.

Answer

nvogel picture nvogel · Apr 25, 2011

I expect you mean top-down design vs bottom-up design - normalization being just one aspect of the methods and principles you would use to complete a database design.

Top-down means you start with a set of requirements. Usually you begin by identifying the types of things that you need to represent data about and then identify the attributes of those things, which will become attributes in tables.

Bottom-up design means you are given some kind of data structures to start with, e.g. a list of attributes or tables and attributes which you need to incorporate into a design. Typically this might happen where you have an existing database or data source, as is common in business intelligence or data integration projects.

Related questions

What are database normal forms and can you give examples?

In relational database design, there is a concept of database normalization or simply normalization, which is a process of organizing columns (attributes) and tables (relations) to reduce data redundancy and improve data integrity. (as written on Wikipedia). As most articles …

Read More
Facebook database design?

I have always wondered how Facebook designed the friend <-> user relation. I figure the user table is something like this: user_email PK user_id PK password I figure the table with user's data (sex, age etc …

Read More
What is the difference between 3NF and BCNF?

Can someone please explain the difference between 3NF and BCNF to me? It would be great if you could also provide some examples. Thanks.

Read More