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.

The following figure shows an ER schema for a database that can be used to keep track of transport

ships and their locations for maritime authorities. Map this schema into a relational schema and

specify all primary keys and foreign keys. Use arrows to specify the relationships. Use descriptive

names for foreign keys.