Normalization:It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties

• Minimizing redundancy
• Minimizing deletion, insertion and update anomalies.

Database normalization is the process of arranging the tables and fields of a relational database to minimize dependency and redundancy. Normalization generally adds dividing large tables into smaller tables and describing relationships between them.

 

Posted Date: 7/30/2012 2:02:32 AM | Location : United States

Ask an Expert

Related Discussions:- Define normalization, Assignment Help, Ask Question on Define normalization, Get Answer, Expert's Help, Define normalization Discussions

Write discussion on Define normalization
Your posts are moderated

Write your message here..

Related Questions

The conceptual level or global level in dbms, The Conceptual Level or Globa... The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

Query, Use a Set operator to create a list of academics who have written or... Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Decomposition, properties of derirable decomposition properties of derirable decomposition

View serialiabilty-labelled precedence graph, how to construct labelled pre... how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

Explain the concept of deadlock, Question: In a multi-user database env... Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Find the employee name, Example -Find the employee name, salary, department... Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart

Sql, example of embedded SQL query example of embedded SQL query

How to control as concurrent tasks, Control as Concurrent Tasks The ex... Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp

MANAGEMWNT OF PRINCILES AND TECHNIQUES., HOW TO SOLVE THE LP Problems by si... HOW TO SOLVE THE LP Problems by simplex method?z=x1+-3x2+2x3

Define deferred update technique of recovery, Discuss deferred update techn... Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact