2. (30 point) Consider the following relations for a database thatkepa track of sales in a car dealership: CAR(Serial no., Manufacturer, Price) CAR. SPAREPARTS(Serial no., Spareparts name, Price) SALE(Sal SALESPERSON Salesperson id., Name, Phone) id., Serial no., Date, Sale price a. (10 pts) Specify the foreign keys for this schema, stating any assumptions you make. b. (8 pts) Populate each relations with two sample tuples. c. (12 pts) 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