03: Logical Database Design

Dr. Rosanne Birney, Mary Lyng, WIT
    • 03: Logical Design

    Logical database design

    Relational Model

    In this lecture you will learn about the Relational Model

    Logical Database Design 1

    In this lecture you will learn about mapping ER diagrams to a set of relations.

    Worked Example

    Here we will step through transforming an ER diagram into a set ot relations

    Exercises

    In your own time transform the ER diagrams into a set of relations

    Logical Database Design 2

    In this lecture we will look at the remainder of steps in Logical Database Design

    Join queries

    SQL

    In this lecture we will introduce the SQL JOIN statement

    SQL 3

    In this lab, we will use the Select statement to retrieve data from two tables.

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