Question $13(5$ points$)$

Consider the following relations for a database that keeps track of automobile sales in a car dealership $($OPTION refers to some optional equipment installed on an automobile$)$:

CAR$($Serial$\_$no$,$ Model, Manufacturer, Price$)$

OPTION$($Serial$\_$no$,$ Option$\_$name, Price$)$

SALE$($Salesperson$\_$id$,$ Serial$\_$no$,$ Date, Sale$\_$price$)$

SALESPERSON$($Salesperson$\_$id$,$ Name, Phone$)$

Specify the foreign keys for this schema, stating any assumptions you make