Define normalization, Database Management System


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.

 

477_normalisation.png

Posted Date: 7/30/2012 2:02:32 AM | Location : United States







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
Related Questions
Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

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 ? m has maximum m mchildren in a B tree.

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? 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 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

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

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 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. 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.