I try to express this SQL in relational algebra. My assumption is as follows. You can see that dept_name is not wrapped by an aggregation function, which is not following the standard. Is my expression correct? What is the right way to express the combination of aggregation an...
Most of the previous translations of relational calculus to relational algebra aimed at proving that the two languages have the equivalent expressive power, thereby generating very complicated relational algebra expressions, especially when aggregate functions are introduced. This paper presents a rule-based...