Consider the following database maintained by a car dealer: • Customer(SSN : integer, name : string, gender : string, ci
Posted: Fri Jul 08, 2022 6:43 am
Consider the following database maintained by a car dealer: • Customer(SSN : integer, name : string, gender : string, city : string) SSN: Customer's Social Security Number, name: Customer's Name, gender: Male or Female, city: Customer's residence city ● Buy Vehicle(VID : integer, SSN : integer, price: real, year : integer) SSN: Customer's Social Security Number, VID: Vehicle's Identification Number, price: car's sale price, year: year of the sale ● Vehicle(VID: integer, make : string, model : string, year : integer) make: car's make, model: car's model, year: production year of the car