Consider the following relations for a database that keeps track of automobile sales in a car dealership
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: