LOL, JMecc you have it all backwards, well, except for S-Video...
1.) Avivo is software, not hardware, you can't connect a VCR to Avivo.
2.) ATI VIVO allows S-Video or Composite in. Not component, composite. Component is better than Composite. VCR's use Composite.
3.) RCA connectors...are a type of connector. Both Composite and Component cables use RCA connectors. Composite is one cable (combined signal), component is three cables
4.) The reason you're probably getting confused is because none of these formats have AUDIO. VIVO cards don't have audio inputs, just a single S-Video input and a single Composite input.
5.) A/V cables that have a yellow, white, and red RCA connector are not composite nor component cables. Instead, they're a combination of 1 Composite Video (yellow cable) plus Left and Right audio cables.