My questions relate to this.

$4.$ Explain the steps needed $($there are three$)$ to JOIN the two tables shown above and show the results in table format $($rows$/$columns$).$

$5.$ Explain how the $($full$)$ OUTERJOIN would work when applied to the two tables shown above and show the results in table format $($rows$/$columns$).$

$6.$ Show the results of a left OUTERJOIN of student to professor:

$7.$ Show the results of a right OUTERJOIN of student to professor:

$8.$ Create the table that would result from $\backslash$pi stu$\_$code$($student$).$

$9.$ Create the table that would result from $\backslash$pi stu$\_$code,dept$\_$code$($student $$ professor$).$

$10.$ Create the relational diagram for the database shown in Figure Q$4-10$ aboveTable name: STUDENT

Database name: Ch$03\_$CollegeQue

Table name: PROFESSOR