DB Logical Design

Overview

Use this skill to define schema semantics that preserve integrity and support maintainable application behavior.

Scope Boundaries

• New domain models must be translated into relational schema.
• Existing schema suffers from integrity drift or unclear constraints.
• Teams need consistent key and relationship semantics.

Core Judgments

• Primary and alternate key strategy.
• Nullability and optionality semantics.
• Referential integrity rules and cascade behavior.
• Audit and lifecycle columns (created/updated/deleted/effective time).