Create test data for a database with foreign keys
There are various free data generators to create test or dummy data for a database, but generally speaking, they don’t handle foreign keys between tables very well. This video shows how to create random data from a free test data site, manipulate the tables in Excel to maintain foreign keys and other advanced referential integrity logic, and then convert the data to SQL insert statements:
Here is the ERD modeled in the video:
Here are the links and documents presented in the video, with comments: