PROBLEM$-1$

Table name: STUDENT

Database name: Ch$03\_$CollegeQue

$\backslash$table$[[$STU$\_$CODE,PROF$\_$CODE$],[100278,],[128569,2],[512272,4],[531235,2],[531268,],[553427,1]]$

Table name: PROFESSOR

$\backslash$table$[[$PROF$\_$CODE,DEPT$\_$CODE$],[1,2],[2,6],[3,6],[4,4]]$

Figure $-1$

create the tables that would result from a natural join, an equijoin, an outer join, a left outer join, and a right outer join on tables in Figure$-1.$

Create the table that would result from student$)$ on tables in Figure$-1.$

Create the table that would result from student $||><mi\; id="EditorElement\_91012">|</mi><mi\; id="EditorElement\_90970">|</mi>$ professor$)$ on tables in Figure$-1.$