I'm a little curious on how different is the dynamic range in each kind of camera.
I know the DR of the human eyes is quit high. But, how different is the DR in SLR, DSLR and P&S cameras? Or is it almost the same?
Yes the larger your sensor and the more light you can capture the higher your dynamic range is likely to be. To put some numbers to it:
Film is often quoted as 7EVs though it's not measured in the same way as the DXO-Mark data so it's not directly comparable.
In general, the larger the photosite, the higher the dynamic range.
So given that DSLR's typically have larger sensors than P&S, they typically have higher dynamic ranges.
SLR's are slightly different, in that the film type dictates dynamic range, not the camera itself.
The human eye has about 24 f-stops of dynamic range, while the camera's range is around 5-9 stops.