You seem to think programming is like entering the cheatcode into a game to enter platinum-level.
If you think "I only have to find the right code and then it is working."
It is very very unlikely that you find exactly a code for 9 pumps where the code fits to your pumps.
The microcontroller-world is not super-standardised like USB-devices.
You have to take care of more details than just "Does the plug fit into the socket?"
For adapting answers to your knowledge-level you should post a description about your knowledge-level about electronics and about programming.
are the pumps totally independent of each other or interconnected in some way?
does each pump have lower and upper limit switches?
what voltage/power are the pumps?
Are you hinting that each pump has it's own power supply? How do you intend to supply each pump station with it's own controlling signals from your Arduino? What length or wire will that be?
yes, also the motors will require a seperate power supply from the Arduino
what is to control the operation of the pumps? limit switches, timers, ?????
if simple limit switches what is the Arduino suposed to do? do you require a microcontroller?
how far apart are the pumps?
No, that will not work because of the delay in the water at the top of the plant takes time to get down to the sensor. In that time the plant will be in flood stage. The program should add a bit of water and wait some time to check the moisture level. Then wait some more and add a bit more water if necessary. loop to continue until moisture sensor is satisfied.
A refinement would be to count the number of times the cycle was tried. If the count exceed some number, raise an alarm because the watering cycle is not getting the plant watered.
I don't understand this question. Relays are switched on or off.
So what do you want to know that goes beyond switching on/off?
I think things will become clearer if you start writing code.
If you are a beginner who is just about start writing code,
new questions will arise. I guess the new questions will be specific and therefore will be easy to answer
Consider how long you will have the pumps turned on as compared to how long the pumps will be turned off. If the off time is longer than the on time, you want the pumps connected between the relay common terminal and the NO or normally off terminal. And you want to usually have relay turned off. How you do that is entirely up to you and how you have the relays connected to your Arduino and the relay power supply.