This blog post is on a personal need. It is in a draft state currently. I hope to write on this later.
I wanted to automate the process from data modelling to testing it with sample data in actual database.
RDB is an abbreviation that I use for requirements database. I try to store all software specifications as structured data in a relational database format.
This document explains how to generate sample data for any database automatically from its database schema defined as DDL
statements.