Logical Data Modeling

This in-depth course describes the relational data model and techniques for developing it. Techniques for gathering end user requirements are described and then applied for development of the data model. Methods for developing the subject area model are provided. The components of the data model – entities, attributes and relationships – are defined, and then brought together to develop a third-normal form data model. Physical data model considerations are then described.

Objectives

Understand the importance of data models
Understand the importance of end user involvement during analysis and modeling activities
Understand the basic modeling concepts and terms
Understand the differences among the different types of models
Understand how to create the subject area model, logical model and physical model
Understand normalization and denormalization
Understand the basics of data warehouse data modeling

Duration 2 Days

Prerequisite None

Course Format Lecture and workshops

Logical Data Modeling

Objectives

Instuctor Claudia Imhoff or Jonathan Geiger