06: Advanced Normalisation

Dr. Rosanne Birney, Mary Lyng, WIT
    • 06: Normalisation 2

    Normalisation example

    Normalisation (unnormalised to 3NF)

    In this lecture we will look at converting an unnormalised relation into a set of 3NF tables.

    Normalisation beyond 3NF

    Boyce Codd Normal Form

    In this lecture we will look at Boyce Codd Normal Form.

    Fourth Normal Form

    In this lecture we will look at Fourth Normal Form.

    Fifth Normal Form

    In this lecture we will look at Fifth Normal Form.

    Data Definition

    SQL

    In this lecture we will look at Data Definition (Create, Alter, and Drop) statements.

    Lab-01 SQL 6

    In this lab, we will look at Data Definition.

    Powered by tutors-ts. Unless otherwise stated, this work is licensed under a Creative Commons Attribution 4.0 International License.