Question $1(5$ points $1$ points per query$)$:

Student: $($Sid$,$ Student$\_$name, GPA, Department$\_$ID$)$

Department: $($Did$,$ Department$\_$name, address$)$

Course: $($Cid$,$ Course$\_$name, credit, Syllabus$)$

Enroll: $($Course$\_$ID$,$ Student$\_$ID$,$ Department$\_$ID$,$ Grade$)$

Department$\_$ID in Student relations is a foreign key referencing the primary key of the Department relation. Course$\_$ID$,$

Student$\_$ID$,$ and Department$\_$ID in the Enroll relation are foreign keys referencing the primary keys of the Course, Student, and

Department, respectively. From the relational schemas illustrated above, use the different relational algebra operators and

operations $(\backslash$rho $,\backslash$sigma $,\backslash$pi $,,,-,)$ discussed in class to build the following queries:

$1.$ Display names and GPAs of students along with the names of their departments.

$2.$ Assume students can be in multiple departments: Display students' names in the $$Computer Science$$ department but not in

the $$Marketing$$ department.

$3.$ Display students $($by name and GPA$)$ who received $100$ points $(100$ included$)$ in the $$Operating Systems$$ course.

$4.$ Display students $($by names and GPA$)$ enrolled in both $$Computer Networks$$ and $$Operating Systems$$ courses but not in

the $$Programming$$ course.

$5.$ Display students $($by name and GPA$)$ from the $$Computer Science$$ department who received $90$ points or more $(90$

included$)$ in the $$Modern Database$$ course and $80$ points or more $(80$ included$)$ in the $$Computer Networks$$ course.