What is the relationship between static and dynamic pressure in fluid mechanics?

In fluid mechanics, static pressure is the pressure exerted by a fluid at rest, while dynamic pressure is the pressure exerted by a fluid in motion. The relationship between static and dynamic pressure is described by the Bernoulli's principle, which states that the total pressure in a fluid system is constant along a streamline. This means that as the dynamic pressure increases, the static pressure decreases, and vice versa.