Home Page
About Us
Contact
SQL School
DB Design
--Database Design Sections--
MAIN INDEX
INTRODUCTION
RELATIONAL DATABASE HISTORY
...Codd's Rules
...Flat Files
KEYS, Primary, Unique and Foreign
...Primary Keys
NORMALISATION BASICS
...Simplified Normal Forms
DATA MODEL BASICS
FORMAL NORMALISATION
...First Normal Form (1NF)
...Second Normal Form (2NF)
...Third Normal Form (3NF)
DATA MODELS - Orphans, 1to1
DATA MODELS - Many To Many
SIMONS RULES
FAQs
REALCON2011 ESSEN, MAY 2011
ESSEN 2011 - Real World Example
Relational Database Design - Simon's Simple Normal Forms
First Normal Form
We must be able to identify a unique record from one or more columns
There is no ordering of rows or columns
There are no duplicate rows
Every cell has just one piece of data
Database Design Index Page
Formal Normalisation 1NF, 2NF , 3NF