Data Validation Guide

Design comprehensive data validation rules with this AI prompt, ensuring data integrity across six core quality dimensions.

What this prompt does

  • Designs comprehensive data validation rules to enforce six core data quality dimensions.
  • Translates business requirements into technical constraints to maintain data integrity.
  • Provides SQL code for constraints, triggers, and validation rules to prevent data quality issues.

How to use this prompt

  1. Fill in the [INSERT YOUR TABLE SCHEMA WITH COLUMN NAMES, DATA TYPES, AND RELATIONSHIPS], [INSERT YOUR SPECIFIC BUSINESS REQUIREMENTS AND VALIDATION RULES], [INSERT YOUR DATABASE SYSTEM - MySQL, PostgreSQL, SQL Server, Oracle, etc.], [INSERT ANY PERFORMANCE CONSTRAINTS OR HIGH-VOLUME REQUIREMENTS]…
  2. Example: "My table schema includes a 'Customer' table with columns 'CustomerID' (INT), 'Email' (VARCHAR), and 'PhoneNumber' (VARCHAR). My business requirements include validating email format and ensuring phone numbers are unique. I use MySQL and need to consider high-volume data entry."

Free prompt — copy, paste and run. Part of the Coding prompts collection in the God of Prompt library.

Related Coding prompts