Data Modeling and Relational Database Design

Course Overview

This course covers the use of Entity Relationship Modeling in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The second part of the course is about the design process and presents the considerations for creating a normalized, stable, maintainable and well defined relational database, such as Oracle9i.

Audience

• Database Administrators
• Business Analysts
• Database Designers

Skills Gained

By the end of the course delegates will be able to:

• Recognize and use patterns in models
• Apply various techniques to optimize the design in an Oracle environment for performance and maintainability
• Transfer ER models into an initial relational database design
• Read, improve, create, use and judge Entity Relationship Models
• Capture business rules and constraints

Prerequisites

• Basic understanding of relational database concepts.

Course Outline

Entity Relationship Modeling

• Why create conceptual models?
• Distinguishing Data and Information
• Tracking Entities in various source materials
• Modeling Subtypes and Supertypes
• Tracking Attributes
• Distinguishing Entities and Attributes
• Establishing Relationships
• Creating appropriate Names for Entities, Attributes and Relationships

Relational Database Design

• Why create a Database Design?
• Creating well structured Names for Database Objects
• Establishing the Basic Mapping of an ER Model to Table Model
• Mapping Entities and Attributes
• Mapping various Types of Relationships
• Mapping Arcs
• Selecting an appropriate Subtype Implementation
• Various ways of Denormalizing your Table Design

Follow On Courses

• Data Modeling and Relational Database Design Self-Study CD Course.

Data Modeling and Relational Database Design / 20000GC13