Database Design:

Please list all the foreign keys in relations that have them in this schema. For each one, please state the foreign key name, the relation in which it is the primary key, and the relation in which it is a foreign key. A sample statement can be: Attribute X which is a foreign key in relation K, references the primary key of relation J.

SALESPERSON (Salesperson-ID, Salesperson-name, Salesperson-phone) CAR (Car-VIN, Model, Manufacturer, Sticker-price) OPTIONALEQUIPMENT (Car-VIN, Option-name, Price) DEAL (Salesperson-ID, Car-VIN, Date-of-transaction, Final-price)