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



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

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: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

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? 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. 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. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro