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

Describe in brief about object oriented design, Describe about Object orien... Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Multivalued dependencies, what is multivalued dependency what is multivalued dependency

Drawbacks of database systems, Drawbacks of Database systems ? Drawbacks of Database systems ?

Oracle RDBMS, compare the features of oracle RDBMS with MySQL and Microsoft... compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Why do so various organizations use mysql, Why do so various organizations ... Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Serialisable schedules, Serialisable Schedules: If the processes of two tra... Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

Distinguish among different kinds of parameters, How can one distinguish am... How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

What are the advantages of object id, What are the advantages of object ID?... What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Give a sample of the dynamic model, Give a sample of the Dynamic Model. ... Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator

List the steps for converting state diagram to the code, List the steps for... List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro