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
construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

In which format database schema is written ? Data base schema is written in the DDL format.


Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

please describe the data base management with the easy example &give the application?

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.