Skip to content
Visual Paradigm Community Circle
  • Examples
    • UML Diagram >>
      • Use Case Diagram
      • Class Diagram
      • GoF Design Pattern
      • Sequence Diagram
      • Communication Diagram
      • State Machine Diagram
      • Activity Diagram
      • Component Diagram
      • Deployment Diagram
      • Package Diagram
      • Composite Structure Diagram
      • Timing Diagram
      • Interaction Overview Diagram
    • System Design & Development >>
      • Data Flow Diagrams
      • Entity Relationship Diagram
      • PERT Chart
    • Enterprise & Business >>
      • ArchiMate Diagram
      • BPMN Diagrams
      • BPMN Process Pattern Catalog
      • Strategic Analysis
      • Organization Chart
      • Decision Table
      • EPC Diagram
      • Fact Model
    • Customer Journey Map
    • General Purposes >>
      • Mind Map Diagrams
      • Radar Chart
      • Breakdown Structure Diagrams
      • Implementation Plan Diagrams
      • Migration Roadmap
      • Cause and Effect Diagrams
    • Misc >>
      • STEPS Wizards
      • On-Demand Model ETL
  • Videos
    • Quick Start
  • Visual Paradigm User’s Guide
Close search bar

Chapter 14. Database Design & Engineering

  • 1. Introduction
    • Database design & management with Visual Paradigm
    • Database configuration
    • Supported database, JDBC drivers and .NET drivers
  • 2. Database Designer’s Guide
    • How to draw an ERD
    • Conceptual, logical and Physical data model
    • Using entity domain
    • Using column domain
    • Applying default schema on ERD
    • Using auto column
    • Entering sample table records for entities
    • Modeling database view
    • Modeling stored procedures in ERD
    • Modeling database triggers in ERD
    • Working with unique constraint
    • Defining ID Generator for primary key generation
    • Applying inheritance strategies
    • Using discriminator column
    • Using Array table
    • Using Partial table
    • Mapping object model to data model
    • Mapping data model to object model
    • Synchronizing object model and data model
  • 3. Database Management Guide
    • How to reverse engineer ERD from database
    • How to reverse engineer ERD from DDL
    • How to generate database from ERD
    • Patching ERD changes to database
    • Copying SQL statements from entities in ERD
  • 4. Programmer’s Guide
    • What is Object Relational Mapping (ORM)?
    • How to generate ORM code from database
    • How to generate ORM code from Class Diagram
    • PersistentManager and Transaction
    • Using ORM Qualifier
    • Using ORM Criteria
  1. Home
  2. Docs
  3. Chapter 14. Database Design & Engineering

Chapter 14. Database Design & Engineering

Download PDF

Articles

  • 1. Introduction
    • Database design & management with Visual Paradigm
    • Database configuration
    • Supported database, JDBC drivers and .NET drivers
  • 2. Database Designer’s Guide
    • How to draw an ERD
    • Conceptual, logical and Physical data model
    • Using entity domain
    • Using column domain
    • Applying default schema on ERD
    • Using auto column
    • Entering sample table records for entities
    • Modeling database view
    • Modeling stored procedures in ERD
    • Modeling database triggers in ERD
    • Working with unique constraint
    • Defining ID Generator for primary key generation
    • Applying inheritance strategies
    • Using discriminator column
    • Using Array table
    • Using Partial table
    • Mapping object model to data model
    • Mapping data model to object model
    • Synchronizing object model and data model
  • 3. Database Management Guide
    • How to reverse engineer ERD from database
    • How to reverse engineer ERD from DDL
    • How to generate database from ERD
    • Patching ERD changes to database
    • Copying SQL statements from entities in ERD
  • 4. Programmer’s Guide
    • What is Object Relational Mapping (ORM)?
    • How to generate ORM code from database
    • How to generate ORM code from Class Diagram
    • PersistentManager and Transaction
    • Using ORM Qualifier
    • Using ORM Criteria
Updated on January 7, 2020

Doc navigation

← Chapter 13. Textual AnalysisChapter 15. Project Management Processes and Tools →
Copyright © 2025 Visual Paradigm Community Circle | Terms of Service | Submit Your Project | Visual Paradigm | Download
Scroll to top