The community college doesn’t need to have the major you want because ideally you’ll be doing your general education requirements and pick up the major at the four year college where you plan to transfer. Since you’re in Cali, there are very structured articulation agreements in place that you can/should follow for ease of a successful transfer.