3. Let us consider the following two tables in a relational database with the gi
ID: 3591125 • Letter: 3
Question
3. Let us consider the following two tables in a relational database with the given data:
Professor
ProfessorName
Department
University
Experience
XXX
Mathematics
Aaa
5
YYY
Computer Science
Bbb
12
ZZZ
Chemistry
Ccc
7
Researcher
ResearchTitle
AuthorName
DateOfPublication
“xyz”
XXX
10-12-2013
“123”
XXX
04-03-2012
“uvw”
ZZZ
07-09-2011
“456”
WWW
05-15-2010
Write a select query using Oracle SQL which will select data from both the given tables and show the result as: (5 point)
Professor
Title
DOP
XXX
“xyz”
10-12-2013
XXX
“123”
04-03-2012
YYY
-
-
ZZZ
“uvw”
07-09-2011
-
“456”
05-15-2010
ProfessorName
Department
University
Experience
XXX
Mathematics
Aaa
5
YYY
Computer Science
Bbb
12
ZZZ
Chemistry
Ccc
7
Explanation / Answer
since from the expected result there is null value for columns from both the tables so we will use full outer join
select p.ProfessorName as Professor, r.ResearchTitle as Title, r.DateOfPublication as DOP
from Professor p
FULL OUTER JOIN Researcher r
on p.ProfessorName = r.AuthorName
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.