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(Sales personid, 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.

Answer rating: 100% (QA)

Foreign keys are a Serial no from OPTION is FK for CAR spare pa... View the full answer