Consider the following database maintained by a car dealer: ● Customer(SSN : integer, name : string, gender : string, c
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
● BuyVehicle(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
Write expressions in Relational Algebra.
Find all pairs of (s, y), where s is a social security number and y is a year, such that the customer with social security number s is a male and he bought at least two Ford cars made in the year y.
● 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
● BuyVehicle(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
Write expressions in Relational Algebra.
Find all pairs of (s, y), where s is a social security number and y is a year, such that the customer with social security number s is a male and he bought at least two Ford cars made in the year y.