I need help with the next TWO SQL question

Concepts Question 1.2: Discuss what type of relationship exists between STUDENT and PROFESSOR. (Recall that relationships can be in the form of 1-1, 1-M, M:N.)

Table name: STUDENT STU CODE PROF CODE 100278 128569 512272 531235 531268 553427 Table name: PROFESSOR PROF CODE DEPT CODE 26 36 Figure 1 Concepts Question 1.1: Using the STUDENT and PROFESSOR tables displayed in Figure 1, discuss (illustrate) the difference between 4 types of joins; 2 inner joins (natural join and equijoin) and 2 outer joins (left-outer join and right-outer join). For the purposes of the outer joins, assume the STUDENT table is the "left" table and the PROFESSOR table is the "right" table. For each of the four different join types, be sure to state what columns are the "join columns". Also be sure to show the results of each join condition. (Consult your textbook; Chapter 3- Section on Join, for a discussion joins.)