Use Figure 3.8 to answer:

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

Transcribed Image Text:

FIGURE 3.8 DIFFERENCE Note STU FNAME George STU LNAME DIFFERENCE EMP FNAME EMP LNAME yields STU FNAME STU LNAME Jones Franklin Lopez George Jones Jane Smith William Turner Jane Smith Peter Robinson Franklin Johnson Peter Robinson Franklin Martin Johnson Susan Rogers Martin Lopez Lopez DIFFERENCE is denoted by the minus symbol -. If the relations SUPPLIER and VENDOR are union-compatible, then an DIFFERENCE of SUPPLIER minus VENDOR would be written as follows: supplier-vendor Assuming the SUPPLIER and VENDOR tables are not union-compatible, producing a list of any supplier names that do not appear as vendor names, then you can use a DIFFERENCE operator. suppler name (supplier)-ndor name (vendor) FIGURE 3.8 DIFFERENCE Note STU FNAME George STU LNAME DIFFERENCE EMP FNAME EMP LNAME yields STU FNAME STU LNAME Jones Franklin Lopez George Jones Jane Smith William Turner Jane Smith Peter Robinson Franklin Johnson Peter Robinson Franklin Martin Johnson Susan Rogers Martin Lopez Lopez DIFFERENCE is denoted by the minus symbol -. If the relations SUPPLIER and VENDOR are union-compatible, then an DIFFERENCE of SUPPLIER minus VENDOR would be written as follows: supplier-vendor Assuming the SUPPLIER and VENDOR tables are not union-compatible, producing a list of any supplier names that do not appear as vendor names, then you can use a DIFFERENCE operator. suppler name (supplier)-ndor name (vendor)