RS232=serial, so yes you should have one, probly two
do you have win95 or win95b it sort of makes a difference, if you right click my computer and go to properties it will say the version, the importence being USB support. You're going to have a hard time finding a low end camera that is NOT usb. Maybe the one you posted above isn't a bad deal, it's in your price range and will work, can't ask for much more. Logitech makes a similar cam for $60, and I know there's another tiny digital out that, about 3"x3" maybe that's the one you posted, I don't know the brand of it, but it works fairly well.
another option might just be to buy a cheap scanner and take pictures of your gear with a regular camera. You'd get better quality images that way and finding a scanner that can connect to your PC shouldn't be a problem.