mercredi 9 novembre 2016

Generate test data with two foreign keys as composite key

I am trying to generate test data regarding 22 players in 75 different training sessions. I have a player table whit the playerId (1,2,3..22) and a training session table with sessionId (1,2,3..75). How can I generate a relational table with test data between these tables with composite keys? Each player can only participate once in each session, and each players shouldn't participate in every training session. CSV is the desired output format. I have tried formulas in excel and online tools like Mackaroo.

Aucun commentaire:

Enregistrer un commentaire