Define normalization, Database Management System


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.

 

477_normalisation.png

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







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
Related Questions

What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

what is correlation in nested query

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4


What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien

Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso

What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where