Outcome 1:Fundamentals of Database Design

Table of Contents

1. Introduction
2. Relationship
3. Key Field
4. The Process of Normalisation
5. Normalisation Example
   1. Step 1
   2. Step 2
   3. 1NF Tables: Repeating Attributes Removed
   4. Step 3
   5. 2NF Tables: Partial Key Dependencies Removed
   6. Step 4
   7. 3NF Tables: Non-Key Dependencies Removed
   8. Summary of Normalisation Rules
   9. SAQ 1
   10. SAQ 2
6. Data Integrity

Normalisation Example

We will demonstrate the process of normalisation (to 3NF) by use of an example. Normalisation is a bottom-up technique for database design, normally based on an existing system (which may be paper-based). We start by analysing the documentation, eg reports, screen layouts from that system. We will begin with the Project Management Report, which describes projects being worked upon by employees. This report is to be 'normalised'. Each of the first four normalisation steps is explained.

Next: Step 1