Question: Which statement is true for the diagram below

1. carid is the primary key for purchases
2. carid is the foreign key for cars.carid
3. customerid is the foreign key for customers.id
4. customerid is the primary key for purchases

Answer: The correct answer of the above question is Option C:customerid is the foreign key for customers.id