Database Design and Data Normalisation

Course Title:
Relational Databases & Data Normalisation Overview Training Course
Course Duration: 1-Day Course
Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours

Course Content
*Session 1: Introduction to Relational Databases
---The Database Approach
---Database Management Systems
---The function of a Database Management System
---The Processing Architecture
---The Schema Architecture
---The Storage Architecture
---An overview of Database System Development
---An overview of general database principles

*Session 2: Conceptual Data Models
---Overview of Entity Models
---Entities and how to identify them
---Attributes and how to identify them
---Relationships and their qualities
---Building an Entity Relationship Diagram
---Resolving many-to-many relationships
---Sub-type and Super-type Relationships
---Arc Relationships
---Recursive Relationships
---Constraints and Assumptions
---Normalization to the First Normal Form (1NF)
---Normalization to the Second Normal Form (2NF)
---Normalization to the Third Normal Form (3NF)
---Exercises: Analyzing a specification
---Creating an Entity Relationship Diagram from it

*Session 2: Conceptual Data Models(continued)
---Normalization to the First Normal Form (1NF)
---Normalization to the Second Normal Form (2NF)
---Normalization to the Third Normal Form (3NF)
---Exercises: Data Normalization producing table specifications and Entity Diagrams

Session 3: The Relational Model
---Relational Structure
---Relational Terminology
---Domains
---A Relational schema
---Candidate keys and Primary Keys
---Foreign Keys
---Key Constraints
---Attribute Constraints
---Implementing Sub-type/Super-type Relationships
---Views
---Denormalization using Pre-joined Tables
---Denormalization using Derived Data
---An Introduction to Structured Query Language (SQL)
---Simple Queries
---Simple Updates of the Data