Assume the school database shown in the appendix. Write the following queries in $(1)$relational algebra and $(2)$SQL state your assumption of the semantics are not clearStudent$\_$id$\_$first$\_$name. last$\_$name,email. major$\_$code. class$\_$year

couse$\_$id$.$ course$\_$name. course $\_$description. credits. department$\_$code