Does overfishing cause a negative or positive effect?

Over fishing of any species has a net negative effect in any part of the ocean or even a lake or pond.

Try setting up an aquarium. Get the balance of fish and plants. Then take the fish or plants away and see what happens to the fish tank. You don't have to physically do it. Make it thinking experiment.