02: Conceptual Database Design

Dr. Rosanne Birney, Mary Lyng, WIT
    • 02: Conceptual Design

    Conceptual database design

    Entities, Entity Types, and Attributes

    In this lecture you will learn about Entities, Entity Types, and Attributes

    Relationships and Relationship Types

    In this lecture you will learn about Relationships and Relationship Types

    Conceptual Database Design 1

    In this lecture you will learn about steps involved in Conceptual Database Design

    Exercises

    In your own time draw an ER diagram for the scenarios

    Conceptual Database Design 2

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

    Aggregate queries

    SQL

    In this lecture we will introduce SQL Aggregate Functions

    SQL 2

    In this lab we will learn about Aggregate Functions.

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