Your TV likely has a shared component (3 RCA) - compositer (2 RCA) video input. The red and white RCA are usually audio.
The TV manual should tell you how to connect the cable box and configure the TV.
If you can get a cable box with HDMI the picture quality will be much better so check with your provider.