Logical Data Modeling and Relational Database Design Overview

Summary
This is a high-level, practical overview of the concepts, notation, and techniques of logical data modeling and relational database design. The course also includes a discussion of scalability and how to achieve scalability in design.

Prerequisites
Familiarity with computing systems and programming concepts is strongly recommended. Prior knowledge of the relational database model is helpful. Overhead projector, whiteboard, flipcharts.

Course Objectives
On completion of this course, the student should be able to
  • Understand modeling techniques used in relational database design
  • Describe logical data modeling techniques
  • Create, interpret and apply entity-relationship diagrams
  • Describe relational database design concepts
  • Recognize the implications of scalability for modeling during the design phase
Length
1 Days

Format
Instructor-led course, with practical written exercises.

Course Outline
  • Introduction
  • Modeling Concepts
    • Introduction to modeling
    • Modeling definitions and considerations
    • Levels of modeling
    • Types of modeling
    • Zachman framework
    • Modeling the system
    • identifying models
  • Logical Data Modeling
    • Introduction to logical data modeling
    • Logical data modeling approaches
    • Developing a data dictionary
    • Entity-Relationship modeling
    • E-R modeling concepts
    • Developing E-R models
  • Introduction to relational database design
  • Scalability
    • Scalability concepts
    • Conclusion

Hardware and Software Requirements

Go to course catalogue