We build a database about Products and Vendors. The business rules are one PRODUCT is supplied by a single VENDOR and each VENDOR can supply many PRODUCTs. Suppose ProductID is the primary key of PRODUCT and VendorID is the primary of VENDOR. Which of the following statement about the foreign key is correct?

VendorID should be used in the PRODUCT entity as the foreign key and ProductID should be used in the VENDOR entity as the foreign key.

ProductID should be used in the VENDOR entity as the foreign key.

VendorID should be used in the PRODUCT entity as the foreign key.

No foreign key is needed to represent the relationship between VENFOR and PRODUCT.