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

Mahesh, task upload task upload

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

Managing databases, 10A.53 Code an Oracle Database trigger to enforce the... 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

Nested query, what is correlation in nested query what is correlation in nested query

Explain the two constraints check and foreign key in sql, Explain the two c... 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

What are the types of indices, Normal 0 false false false ... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Dataware house, multidimensional data model multidimensional data model

What are the objectives of query processing, What are the objectives of que... 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, Determine the steps of ... 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, What are the three classes of... What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where