Rules of data normalisation, Database Management System

Rules Of Data Normalisation

 Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process:

1.   Eliminate Repeating Groups: Make an individual relation for each set of related attributes, and give every relation a primary key.

2.   Eliminate Redundant Data: If an attribute relies on only part of a multi- attribute key, remove it to an individual relation.

3.   Eliminate Columns Not Dependent On Key: If attributes do not give to a description of the key, remove them to a individual relation.

4.   Isolate Independent Multiple Relationships: No relation may have two or more 1:n or n:m relationships that are not directly linked.

5.   Isolate Semantically Related Multiple Relationships: There may be practical constrains on information that give explanation for separating logically related many-to-many relationships.

Let's define these steps of Normalisation through an instance:

 Let us make a file of all the employees in the company. In the original employee file, every employee name is pursued by any databases that the member has experience with. Some may know many, and others may not know any.

Emp-ID

Emp-Name

Database-Known

Department

Department- Loc

1

Gurpreet

Malhotra

Oracle,

A

N-Delhi

2

Faisal Khan

Access

A

N-Delhi

3

Manisha Kukreja

FoxPro

B

Agra

4

Sameer Singh

DB2, Oracle

C

Mumbai

Posted Date: 3/7/2013 2:25:30 AM | Location : United States







Related Discussions:- Rules of data normalisation, Assignment Help, Ask Question on Rules of data normalisation, Get Answer, Expert's Help, Rules of data normalisation Discussions

Write discussion on Rules of data normalisation
Your posts are moderated
Related Questions
Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

What are the categories of SQL command? SQL commands are separated in to the following categories: 1. Data - Definitition Language 2. Data Manipulation language 3. Dat

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Design a gennalization and specialization hierarchy for an automobile sales company

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

What is the major advantage of object-oriented programming paradigm? The ability to modify the explanation of an object without affecting the rest of the system is the main adv

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe