Rules of data normalisation, Database Management System

Assignment Help:

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


Related Discussions:- Rules of data normalisation

Attributes, Attributes and its types explain?

Attributes and its types explain?

Distinguish among different kinds of parameters, How can one distinguish am...

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

Database integrity and database security, Question : (a) Differentiate ...

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D

What is multivalued attribute, What is Multivalued Attribute? Multival...

What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.

NORRMALIZATION, Home based assignment Consider an ORDER table with the foll...

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

State about the advance object design, ADVANCE OBJECT DESIGN Introduct...

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Query by example, Illustrate how you can use QBE to perform logical AND and...

Illustrate how you can use QBE to perform logical AND and OR operation

Determine the programming language structures, What is the most significant...

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu

ER diagrams, explain exhaustively the problems associated with ER diagrams....

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

MIS, We face problem of stock Opening balance and closing balance in Minus...

We face problem of stock Opening balance and closing balance in Minus

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd