Assignment #$2$

MSIT $630$ Database Systems

Total: $50$ points

Consider the relation, r$,$ shown below. Give the result of the following query: $(5$ points$)$

$\backslash$table$[[$building$,$room$\_$number,time$\_$slot$\_$id$,$course id$,$sec id$],[$Westley$,359,$A$,$BIO$-101,1],[$Westley$,359,$B$,$BIO$-101,2],[$Saucon$,650,$A$,$CS$-101,2],[$Saucon$,550,$C$,$CS$-319,1],[$Painter$,705,$A$,$BIO$-305,1],[$Painter$,705,$D$,$MU$-199,1],[$Painter$,705,$B$,$CS$-101,1],[$Painter$,402,$D$,$FIN$-201,1]]$

SELECT building, room$\_$number, time$\_$slot$\_$id$,$ count$()$

FROM $r$

GROUP BY building, room$\_$number, time$\_$slot$\_$id with rollup;