|
|
|
ORA07DES-9i-01-SG
Oracle Designer Data Modeling (3 days)
Description
This course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous ‘real-world’ problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to attendees. This course may be presented using the modeling syntax of Oracle Designer or independent of any specific modeling tool. This course is alternately named "Relational Database Design."
Audience
All database professionals including developers, database administrators and designers. Non-technical professionals such as business analysts and others concerned with logical database design will also benefit.
Suggested Next Courses
• The Sideris course Introduction To Oracle9i SQL
• The Sideris course Introduction To Oracle9i PL/SQL Language
• The Sideris course Oracle9iDS Designer Systems Analysis & Modeling
Objectives
• Build a series of logical data models
• Transform a logical model into a physical model
• Use the concepts of supertype and subtypes to solve modeling problems
• Learn the mistakes common to many data models
Course Outline
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
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
TRANSFORM MODEL TO LOGICAL DATABASE
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!
WHAT IS A RELATIONAL DATABASE? • Relational Database Terms • Views • Indexes • Constraints • Sequences • Triggers • A Logical Database Design• Distributed Database & Data Partitioning
CLASSIC STRUCTURES & PATTERNS • Master-Detail (Generic) • Master-Detail (Invoice specific) • Bill-of-Materials (data model) • Bill-of-Materials (relational schema) • Organization Unit Hierarchy
SAMPLE MODELS • The Connection Trap (Solution) • A Credit Card Company (Moderate) • Refine Air Travel Model (Moderate)
|
|
|
|
|
