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

Explain the paths in the association network, Explain the paths in the asso... Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Objectives-database recovery and security, Objectives Define the te... Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

Explain differance between primary and secondary storage, Explain differanc... Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

Need for multiple access paths, Need for Multiple Access Paths In pract... Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

Many-to-many relationship, For each m:n relationship type R, we make a new ... For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

Give an example of multiple inheritance, Give an example of multiple inheri... Give an example of multiple inheritance.  One example of multiple inheritance is a committee for students affair which include faculty and administrative staff member.

Explain Lock-Based protocols, # ???? .. # ???? ..

Describe queries with complex types, Describe queries with complex types? ... Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Hierarchical model is also known by, Hierarchical model is also known by? ... Hierarchical model is also known by? A hierarchical model is also known as a Tree structure.

Normalisation, what is 3nf what is 3nf