8. Using the STUDENT and PROFESSOR tables, illustrate the difference between a natural join, an equijoin, and an outer join.

9. Create the table that would result from stu_code(student).

10. Create the table that would result from stu_code, dept_code (student professor).

FIGURE 3.1 STUDENT TABLE ATTRIBUTE VALUES Table name: STUDENT Database name: Ch03_TinyCollege STU NUM STU LNAME STU FNAME STU_INIT| STU_DOB | STU_HRS STU_CLASS STU_GPA STU_TRANSFER DEPT CODE STU PHONE PROF_NUM 321452 Bowser William C 12-Feb-1985 42 So 2.84 No BIOL 2134 205 324257 Smithson Anne K 15-Nov-1991 81 Jr 3.27 Yes CIS 2256 222 324258 Brewer Juliette 23-Aug-1979 36 So 2.26 Yes ACCT 2256 228 324269 Oblonski Water H 16-Sep-1986 66 Jr 3.09 No CIS 2114 222 324273 Smith John D 30-Dec-1968 102 Sr 211 Yes ENGL 2231 199 324274 Katinga Raphael P 21-Oct-1989 114 Sr 3.15 No ACCT 2267 228 324291 Robertson 324299 Smith Gerald T 08-Apr-1983 120 Sr 3.87 No EDU 2267 311 John B 30-Nov-1996 15 Fr 2.92 No ACCT 2315 230 STU_NUM STU_LNAME Student number Student last name STU_FNAME STU_INIT STU DOB STU_HRS STU_CLASS STU_GPA STU TRANSFER DEPT_CODE STU_PHONE PROF_NUM Student first name =Student middle initial Student date of birth = Credit hours earned = Student classification = Grade point average = Student transferred from another institution Department code = 4-digit campus phone extension = Number of the professor who is the student's advisor