closeHello! Click here if you would like to know what Factolex is about.

Database normalization

One more term with the same name exists. Show the other term
Start collecting facts
These are the best facts for Database normalization, collected by our users from the web:
(You can find the source through the icon at the end of each fact)
  1. sometimes referred to as canonical synthesis, is a technique for designing relational database tables to minimize duplication of information and, in so doing, to safeguard the database against certain types of logical or structural problems, namely d

    Source: Wikipedia Unhappy with this fact? more info
    created by user picturefactobot on December 11, 2008
  2. the elimination of redundancy in databases

    Source: Wikipedia Unhappy with this fact? more info
    created by user picturefactobot on December 11, 2008
  3. For example, when multiple instances of a given piece of information occur in a table, the possibility exists that these instances will not be kept consistent when the data within the table is updated, leading to a loss of data integrity

    Source: Wikipedia Unhappy with this fact? more info
    created by user picturefactobot on December 11, 2008
  4. A table that is sufficiently normalized is less vulnerable to problems of this kind, because its structure reflects the basic assumptions for when multiple instances of the same information should be represented by a single instance only

    Source: Wikipedia Unhappy with this fact? more info
    created by user picturefactobot on December 11, 2008
  5. Higher degrees of normalization typically involve more tables and create the need for a larger number of joins, which can reduce performance

    Source: Wikipedia Unhappy with this fact? more info
    created by user picturefactobot on December 11, 2008
Displaying the top 5 of 23 facts in total. Show all 23 factsShow 3 more or all 23 facts
Do you know more? Submit a new fact

Add a new fact

A fact should only contain one sentence, describing an aspect of the term.

Fact
Example: located on the west coast of the U.S
Source
Tags
optional

Example: geography location -- separate tags with spaces

Add one more fact or give me some inspiration from:

More lexica »Featured Lexica

Look at what our users have created already.

Feedback

Please tell us what you think about our project

Contribute

On Factolex you can add facts and terms that you believe are missing.

To be sure that the term hasn't already been entered, please use the search function before doing so.

Home  |  About  |  FAQ  |  Feedback  |  Tools  |  Stats  |  Contact Us  |  API  |  Blog
Change language to: