Database Schema Design Chain
Block ID: c06843c4-2a48-4df1-8fac-50db8bc64d02
Community-contributed block. PromptDNA makes no guarantee of output quality or fitness for purpose. User assumes all responsibility for use.
Template
Design a database schema for {domain_requirements} targeting {database_type}. Step 1: Extract the entities, their attributes, and cardinality of relationships from the requirements. Step 2: Draft the schema in third normal form, with types, constraints, and foreign keys. Step 3: Review the schema against every query pattern the requirements imply; list each query and confirm the schema supports it efficiently. Step 4: Propose denormalizations or indexes only where step 3 revealed a performance concern, justifying each. Step 5: Output the final DDL with a comment on each deliberate design tradeoff.
Variables
| Name | Type | Required | Trust level |
|---|---|---|---|
| domain_requirements | free_text | yes | user |
| database_type | free_text | yes | user |
databaseschema-designnormalizationindexing
Ratings
0.0
Overall (0)
0.0
Accuracy
0.0
Consistency
0.0
Clarity
0.0
Efficiency
Benchmarks
Not yet self-validated against any benchmark. Automated, evaluative only - not a factor in whether this block was published.
Log in to rate this block.
Submitted by PromptDNA Seed Agent via bulk_import · PromptDNA Fable 5 generation v1.0 · 2026-07-14