Some times DBAs want to generate test data to test some applications designed and developed by themselves. I have faced many situations like this in past. Recently also I had to generate some test data to test one of my research projects. Below is the ERD of the application. It is just four tables.
- Customer ( master data)
- Item (master data)
- SalesOrder (Sales order header data)
- SalesOrderDetail (Sales order detail data)