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 clear

Student$\_$id$\_$first$\_$name. last$\_$name,email. major$\_$code. class$\_$year

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

Student$\_$id$,$ course$\_$id$,$ semester, grade

major$\_$code. major$\_$name. department$\_$code

department$\_$code. department$\_$name