Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
CAR (Serial-No, ModConsider the following relations for a database that keeps track of auto sales in a car dealership (Option refers to some optional...
CAR (Serial-No, ModConsider the following relations for a database that keeps track of auto sales in a car dealership (Option refers to some optional equipment installed on an auto):el, Manufacturer, Price), OPTIONS (Serial-No, Option-Name, Price), SALES (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 example tuples, and then give an example of an insertion in the SALES and SALESPERSON relations that violates the referential integrity constraints and of another insertion that does not.