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

Intersection, If R1 and R2 are two union compatible relations or functions,... If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,

What is oom, What is OOM? Object oriented modeling is an approach by wh... What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does

Dbms of company, what should be included in this??? what should be included in this???

Write query to list the staff who work within the branch, Consider the foll... Consider the following relations: BRANCH( bno, street, area, city, pcode, Tel_no, Fax_no) STAFF( Sno, Fname, Lname, address, position , salary, bno) Express the subsequent qu

What are composite attributes, What are composite attributes? Composite... What are composite attributes? Composite attributes can be separated in to sub parts.

01a_ImportCasting.xlsx, 01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercise... 01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercises You work as a production assistant in the office of the Green Man Theatre. One of your duties is to maintain the company datab

Cascading rollback, explain cascading rollback explain cascading rollback

Lock, lock and types of lock lock and types of lock

Key, Q.   Explain the terms key constraints participation constraints and m... Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Construct an er diagram for a hospital, Construct an ER diagram for a hospi... Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.