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

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM... Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Explain the rules for creating a labelled precedence graph, Explain the rul... Explain the rules for creating a labelled precedence graph for testing view serializability.            Ans: A schedule S is view serializable if it is view equivalent to a ser

A b-tree of order how much children m has maximum, A B-tree of order how mu... A B-tree of order how much children m has maximum ? m has maximum m mchildren in a B tree.

Post vbulletin hack and new server problem, Project Description: My VBul... Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

What is called as recursive partitioning, What is called as recursive parti... What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Define the canonical cover, Define the Canonical cover Ans: A canonical... Define the Canonical cover Ans: A canonical cover F c for F is a set of dependencies like F logically implies all dependencies in F c , and F c logically entails all dependen

Create a table for database transformation , Step 1 . Using Oracle, create ... Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

Ways to suggest the dba, a)  Suppose we updated the catalog tables in real ... a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few

Describe analysis of access paths, Describe analysis of access paths To... Describe analysis of access paths To describe analysis of access paths, consider an example of the design of a company's employee skills database. A part of the object model fr

Define seek time, Define seek time. The time for repositioning the arm ... Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.