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
Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

please i request for your assistance in developing a case-based online phone repair

The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each.       Ans: Completeness Constraints

What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t

Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On  delete  Cascade :  Using  this  key  whenever  a  parent  row  is  removed  in  a referenced

Write short notes on Schema diagram.  A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema  diagram. Every relation appea

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager