Data Normalisation Basics

Description

Systems Analysis & Design (Data Normalisation) Note on Data Normalisation Basics, created by callumh93 on 12/05/2013.
callumh93
Note by callumh93, updated more than 1 year ago
callumh93
Created by callumh93 about 12 years ago
78
0
1 2 3 4 5 (0)

Resource summary

Page 1

What is data normalisation?Is the process of organising the fields and tables of a relational database to minimize redundancy and dependency

First Normal Form (1NF)For a database to be in first normal form (1NF), the following rules have to be met for each table in the database There are no columns with repeated or similar data Each data item cannot be broken down any further. Each row is unique i.e. it has a primary key Each field has an unique name

Atomicity 'Atomic' is the word used to describe a data item that cannot be broken down any further.

Second Normal Form (2NF)Requires that the data model is in 1NF already and that the data model leads to entities containing attributes that are dependent on the whole key identifier.

New Page

Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

DFD Basics
callumh93
Game and Sarson Symbols
callumh93
Relational Algebra
callumh93
2014 GCSE History Exam Paper Setup
James McConnell
GCSE REVISION TIMETABLE
TheJileyProducti
Bay of Pigs Invasion : April 1961
Alina A
Carbohydrates
Julia Romanów
MAPA MENTAL
blanca beatriz m
New GCSE Maths
Sarah Egan
B7 Quiz - The Skeleton, Movement and Exercise
Leah Firmstone