- Consider The Following Database Maintained By A Car Dealer Customer Ssn Integer Name String Gender String Ci 1 (139.53 KiB) Viewed 30 times
Find all models made by Ford (i.e. the make is Ford) such thatvehicles of these models were bought by at least 2 female customersfrom Chicago
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