In Example 21.3 we talked about a relation Cars at Dealer 1 that conveniently had an attribute autoTrans with only the values ' yes ' and ' no '. Since these were the same values used for that attribute in the global schema, the construction of relation Autos Whse was especially easy. Suppose instead that the attribute Cars. Auto Trans has values that are integers, with 0 meaning no automatic transmission, and 1 > 0 meaning that the car has an i-speed automatic transmission. Show how the translation from Cars to Autos Whse could be done by a SQL query.
Example 21.3
Suppose for simplicity that there axe only two dealers in the Aardvark system, and they respectively use the schemas
