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)

First, specify the foreign keys for this schema, stating any assumptions you make. Next,

populate the relations with a few sample tuples, and then give an example of an insertion

in the SALE and SALESPERSON relations that violates the referential integrity

constraints and of another insertion that does not