Computer Sciene of Udayana State University

April 26, 2009

Normalized Databases

Filed under: Computer Science — ignaga @ 2:34 AM

  • Normalized databases have a design that reflects the true dependencies between tracked quantities, allowing quick updates to data with little risk of introducing inconsistencies.
  • Instead of attempting to lump all information into one table, data is spread out logically into many tables.
  • Normalizing the data is decomposing a single relation into a set of smaller relations which satisfy the constraints of the original relation.
  • Redundancy can be solved by decomposing the tables. However certain new problems are caused by decomposition.
  • Normalization helps us to make a conscious decision to avoid redundancy keeping the pros and cons in mind.
  • One can only describe a database as having a normal form if the relationships between quantities have been rigorously defined.
  • It is possible to use set theory to express this knowledge once a problem domain has been fully understood, but most database designers model the relationships in terms of an “idealized schema”. (The mathematical support came back into play in proofs regarding the process of transforming from one form to another.)
  • The transformation of conceptual model to computer representation format is known as Normalization.

Advertisements

1 Comment »

  1. […]   Associated Article: Computer Sciene of Udayana State University […]

    Pingback by Normalized Databases | Ragnarok Connection — July 16, 2014 @ 5:06 AM | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: