Can I transfer video tapes onto CD's - Video Cameras

A lot depends on what type of video tape you use and where do you want to play the DVDs (CDs are for audio recording only). If tape is compact VHS then you can buy a simple DVD Recorder VHS VCR combo player and transfer across easily provided you have the compact VHS cassette module.
http://www.gumtree.com.au/s-ad/reservoir/tv-dvd-players/lg-v271-vcr-dvd-player-combo-recorder-6-head-hi-fi-stereo/1073556241

For other type of video camera tapes you will have to try other methods like connect camera with tape to a DVD recorder and directly burn the DVDs. You can buy attachments and software for PC but I have found these very cumbersome to work with.