Spin Dynamics Of Density Wave And Frustrated Spin Systems Probed By Nuclear Magnetic Resonance