Agent Skills: relational-database-design

Distills a logical relational-database design methodology into rules an agent applies while designing or reviewing a schema. Covers the design sequence (mission → tables → fields → keys → relationships → business rules → views → integrity review), one-subject-per-table decomposition, atomic single-valued fields, candidate/primary/foreign keys, relationship types with deletion rules and participation, the four levels of data integrity, database-vs-application business rules, validation tables, views for derived data, and the flat-file / spreadsheet / RDBMS-driven antipatterns to avoid. The structure is logical and RDBMS-agnostic, and normalized by construction. Use when designing a new relational schema, reviewing or refactoring an existing one, resolving redundant or repeating data, choosing keys, modeling relationships, or deciding where a constraint belongs.

UncategorizedID: pproenca/dot-skills/relational-database-design

Install this agent skill to your local

pnpm dlx add-skill https://github.com/pproenca/dot-skills/relational-database-design

Skill Files

Browse the full folder contents for relational-database-design.

Download Skill

Loading file tree…

Select a file to preview its contents.