Consider The Following Database Maintained By A Car Dealer Customer Ssn Integer Name String Gender String Ci 1 (139.53 KiB) Viewed 44 times
find the social security numbers of customers who bought atleast one car of every make and model (e.g., Ford Mustang; heremake is Ford and model is Mustang).
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!