O O O Create the table that would result from stu_code, dept_code (student professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES E Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF CODE 100278 128569 512272 531235 631268 553427 Table name: PROFESSOR PROF CODE DEPT CODE myhp 266 12 26 36 To upload and submit your accionmant click the Chonce Fila hutton halow to find and colont vour cavad document Maba cure that the

Create the table that would result from \( \pi_{\text {stu_code, dept_code }} \) (student professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT \begin{tabular}{|r|r|} \hline STU_CODE & PROF_CODE \\ \hline 100278 & \\ \hline 120569 & 2 \\ \hline 512272 & 4 \\ \hline 531235 & 2 \\ \hline 531268 & \\ \hline 553427 & 1 \\ \hline \end{tabular} Table name: PROFESSOR \begin{tabular}{|c|} \hline PROF_CODE | DEPT_CODE \\ \hline 12 \\ 26 \\ 36 \\ 44 \\ \hline \end{tabular} Create the table that would result from \( \pi_{\text {stu_code, dept_code }} \) (student professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT \begin{tabular}{|r|r|} \hline STU_CODE & PROF_CODE \\ \hline 100278 & \\ \hline 120569 & 2 \\ \hline 512272 & 4 \\ \hline 531235 & 2 \\ \hline 531268 & \\ \hline 553427 & 1 \\ \hline \end{tabular} Table name: PROFESSOR \begin{tabular}{|c|} \hline PROF_CODE | DEPT_CODE \\ \hline 12 \\ 26 \\ 36 \\ 44 \\ \hline \end{tabular}