WA1387 Oracle Designer Data Modeling Course Outline
 
1. DATA MODELING PRINCIPLES
  • What Is Data Modeling?
  • Related Methodologies
  • What You Can Do With A Data Model
  • What Can Go Wrong Without A Data Model
  • ERwin Model Notation
  • SDesignor Model Notation
  • Oracle Designer Model Notation
  • Logical Database Design
2. BUILDING A DATA MODEL
  • Building A Very Simple Model
  • How To Start A Data Model
  • Identifying Entities
  • Identifying Attributes
  • Identifying Relationships
  • Certify the Model With Normalization
  • Oracle Designer Notation
3. TRANSFORM MODEL TO LOGICAL DATABASE
4. SEMANTIC & OBJECT ORIENTED CONCEPTS
  • Semantic Data Modeling
  • OO Concepts
  • Domains
  • Flaws That Probably Exist In Your Entities!
  • Flaws That May Exist In Your Attributes
  • SuperTypes & SubTypes
  • Generalization and Specialization
  • Sample Specialization
  • Subtype Constraints
  • Arc
  • Lattice
  • Some Scary Stories!
5.WHAT IS A RELATIONAL DATABASE?
  • Relational Database Terms
  • Views
  • Indexes
  • Constraints
  • Sequences
  • Triggers
  • A Logical Database Design
  • Distributed Database & Data Partitioning
6.CLASSIC STRUCTURES & PATTERNS
  • Master-Detail (Generic)
  • Master-Detail (Invoice specific)
  • Bill-of-Materials (data model)
  • Bill-of-Materials (relational schema)
  • Organization Unit Hierarchy
7. SAMPLE MODELS
  • The Connection Trap (Solution)
  • A Credit Card Company (Moderate)
  • Refine Air Travel Model (Moderate)