It is useful to have /tmp a partition since you can then mount
it noexec which can help secure your box.
I also like having the db and logs on seperate partitions
even with one drive since it means you can insure that they won't run out of space due to large files being created somewhere else.