Exercise 5 | Complete Solution

Exercise 5
Use SQL to do this exercise. Part 2: Create two tables similar to figure 7.1 and 7.2. Use a SQL statement to demonstrate the equijoin between the two tables. Refer to: Rischert, A. (2010). Chapter 7: Equijoins. In Oracle SQL by example (pp. 286-302). New York: Learning Solutions
Here are those 2 tables you will create and demonstrate the equijoin between them.
Table COURSE
COURSE_NO    DESCRIPTION    MODIFIED_DATE
10    Technology Concepts    05-APR-07
20    Intro to Information systems    05-APR-07
25    Intro to Programming    05-APR-07
80    Programming Techniques    05-APR-07
100    Hand’s On Windows    05-APR-07
120    Intro to Java Programming    05-APR-07
122    Intermediate Java Programming    05-APR-07
124    Advanced Java Programming    05-APR-07
125    Java Developer I    05-APR-07
130    Intro to Unix    05-APR-07

Note:  The COURSE_NO column is the Foreign Key to the COURSE table.
Table SECTION
SECTION_ ID    COURSE_NO    SECTION_NO    LOCATION
80    10    2    L214
81    20    2    L210
82    20    4    214
83    20    7    509
84    20    8    210
85    25    1    M311
86    25    2    L210
87    25    3    L507
88    25    4    L214
89    25    5    L509
90    25    6    L509
91    25    7    L210
92    25    8    L509
93    25    9    L507
141    100    1    L214
142    100    2    L500