Collective dynamics and related physical properties of two and three dimensional classical and quantum condensed matter plasmas