These two part series were really useful. Thanks.

Any suggestions on how to generate test data for following scenarios:

1. Two tables linked using PK-FK relationship e.g. Product Category and Product Subcategory

2. Self Referential Tables like the Employee table with EmployeeId, ManagerId, <Other employee details>

3. Using the master tables in 1, 2 generate a table that has ProductFK, EmployeeFK, <Some data> as in a Data warehouse.