Logical Data Modeling

Summary

This course explains how to perform logical data modeling (LDM) and design a database suitable for the type of data it will hold. Participants will learn how to transform business information requirements into a logical data model and initial database design. This course includes a series of exercises in basic and advanced design.

Prerequisites

A general introduction to databases is recommended but not required. This course should be followed by the Relational Database Design course. SQL, Sybase, and Oracle courses are also available.

Course Objectives

On completion of this course, the student should be able to

Identify and define business information requirements
Recognize the principles behind data architectures and corporate data models
Select an appropriate approach to data modeling
Create a logical data model
Describe the transition from a logical data model to a physical relational database design
Use advanced techniques to refine the data model

Length

3 Days

Format

Instructor-led course, with practical exercises.

Course Outline

Introduction
- Definition, benefits, and risks
- Corporate vs. project data modeling
- Logical vs. physical data modeling
- Building the LDM
Approaches to Logical Data Modeling
- Selecting the right approach
Entity-Relationship Modeling
- Why E-R modeling?
- CASE tools
- E-R modeling concepts
- Relationships
  - Connectivity and cardinality
  - Optionality
  - Named
  - Many-to-many
- Validating E-R models
Transactions vs. Decisions
- DSS vs. OLTP
- Data warehouse
- Dimensional data
- Star and snowflake schema
- Snowflake design issues
Transactions vs. Decisions
- Domains
- Derived and calculated attributes
- Multi-valued attributes
- Primary and foreign keys
- Normalization
Modeling for Decision Support
- OLTP
- DSS
- Dimensional data
- Star schema
- Snowflake schema
- Developing the LDM
Advanced Entity Relationship Modeling
- Dependent and associative entities
- Subtypes and supertypes
- Null attributes and recursive relationships
- Naming objects

Hardware and Software Requirements

This course does not require computers, though they may prove useful.

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 3

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 4

Notice: Undefined variable: REMOTE_USER in /var/www/datadeliverance/inc/trademarks.inc on line 7

Notice: Undefined index: HTTP_REFERER in /var/www/datadeliverance/inc/trademarks.inc on line 7

Oracle and Java are registered trademarks of Oracle and/or its affiliates. PL/SQL and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries. MVS is a registered trademark of the International Business Machines Corp. in the U.S. or other countries or both. Motif, OSF/1, UNIX, and the "X Device" are registered trademarks and IT DialTone and The Open Group are trademarks of The Open Group in the U.S. and other countries. All other trademarks are the property of their respective owners.