So what I want is to insert around 50,000 and possibly more records into the database but I have a relational database so I'm not sure how to handle this.
How I want the flow for each iteration:
Insert a student who's table structure is:
i60(.)tiny pic(.)com/34856ds.png
year_enrolled is randomized
status whether graduate/undergraduate is randomized
names are randomized
college_code is randomized(there's a table for this)
degree_code is randomized(there's a table for this)
After inserting the student,
I want to insert random values for each course on the student based on his degree, like let's say the student is taking up ComSci
i59(.)tiny pic(.)com/5e5tz4.png
I'd like to populate random values on the student's grade records
i57(.)tiny pic(.)com/2m6agkl.png
======
How can I achieve this?
How I want the flow for each iteration:
Insert a student who's table structure is:
i60(.)tiny pic(.)com/34856ds.png
year_enrolled is randomized
status whether graduate/undergraduate is randomized
names are randomized
college_code is randomized(there's a table for this)
degree_code is randomized(there's a table for this)
After inserting the student,
I want to insert random values for each course on the student based on his degree, like let's say the student is taking up ComSci
i59(.)tiny pic(.)com/5e5tz4.png
I'd like to populate random values on the student's grade records
i57(.)tiny pic(.)com/2m6agkl.png
======
How can I achieve this?