In my application, I have a set of data which will be added initially. This data will then be used in the application. Eg employees will be added. This data will then be used in creating projects,timesheets etc. So when I automate
1) do i just use the data available in the system
2) do i create a set of employees then use each for various scripts
3) do i just create an employee and use it in a script. delete and create it again for another script.
I tend to make sure my automation can set up and remove all it's test data when needed. This way you don't have to rely on a specific state of the system or a particular database already be setup. Then when you create your data you know you have a good starting point (plus you have just tested the sata input of your application). Then make sure you clean up after yourself for the next iteration.
If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue!