Three tables are givenStudent: studentNO, firstName, lastName, studentProgramProfessor: professorID, professorProgram, professorNameStudent_professor: studentNO, professorID, mentorComplete the following requirements:Using the UNION operator, do a full outer join to display the student last name student program, professor name and professor program. Referring to the model created in step 2, determine the PK/FK relationships to build the SQL joining the three Create a query/subquery to display student first name, last name and program. The student program must be same as that in the professor table and the professor program name starts with a ‘C’. This query will use a subquery and not a join.

1. SELECT last name,studentProgram FROM Student UNION SELECT professor name, Professor Program FROM…

Answered: Three tables are given Student:…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Three tables are given

Student: studentNO, firstName, lastName, studentProgram

Professor: professorID, professorProgram, professorName

Student_professor: studentNO, professorID, mentor

Complete the following requirements:
1. Using the UNION operator, do a full outer join to display the student last name student program, professor name and professor program. Referring to the model created in step 2, determine the PK/FK relationships to build the SQL joining the three
2. Create a query/subquery to display student first name, last name and program. The student program must be same as that in the professor table and the professor program name starts with a ‘C’. This query will use a subquery and not a join.

Expert Solution