Question: Table name: STUDENT Database name: Ch03 CollegeQue STU CODE PROF CODE 100278 128569 512272 531235 531268 553427 Table name: PROFESSOR PROF CODE DEPT CODOE 1

Table name: STUDENT Database name: Ch03 CollegeQue STU CODE PROF CODE 100278 128569 512272 531235 531268 553427 Table name: PROFESSOR PROF CODE DEPT CODOE 1 2 2 6 3 6 FIGURE Q3.8 The Ch03_CollegeQue Database Tables 8. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate a natural join between STUDENT and PROFESSOR. The resulting table will only include STU_CODE, PROF_CODE, and DEPT_CODE (3 points) 9. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate a Left Outer Join of STUDENT to PROFESSOR. The resulting table will only include STU_CODE, STUDENT.PROF_CODE, PROFESOR.PROF_CODE, and DEPT CODE (3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
