Camera - follow path and change rotation
For the object add a Follow Path constraint and select the curve you want the object to follow as target. Enable Follow Curve and Enable Animate path.



Your object will follow that path:



Add a second curve.

Place your camera at the same in the same origin point of your second curve (the you want to use as travel path) and add a Follow path constraint with the curve as target, and animate path enabled:



Your camera will travel on that path.



On the camera add a Track to constraint with the object as Target, To -Z and Up Y.