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
What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

An instance of relational schema R (A, B, C) has distinct values of A including NULL values. then A is a candidate key or not? If relational schema R (A, B, C) has distinct val

a method named WonGame that checks each letter in the word is matched by its label

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact

write a database program for concurrency transaction in a bank

Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the