Equijoin Demonstration and SQL Implementation for Relational Tables: An Analysis of COURSE and SECTION Data

Preview 2 of 3 pages

See the first 2 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Equijoin Demonstration and SQL Implementation for Relational Tables: An Analysis of COURSE and SECTION Data 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 SECTIO N _ 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
Page 2

1 more page in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.