Given the two relations, R1 and R2 Relation R1: Name Empld DeptName Harry 3415 Finance Sally 2241 Sales George 3401 Finance Harriet 2202 Sales Jim 5678 Advertizing Relation R2 DeptName Manager Finance George Sales Harriet

Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 3RQ: Using tables named T1 and T2, write a query example for each of the three join types you described...
icon
Related questions
Question
Given the two relations, R1 and R2
Relation R1:
Name Empld DeptName
Harry 3415 Finance
Sally 2241 Sales
George 3401 Finance
Harriet 2202 Sales
Pim
5678 Advertizing
Relation R2
DeptName Manager
Finance
George
Sales
Harriet
Production Charles
How many rows will be in the table of R1 LEFT OUTER JOIN R2?
3
O 2
4
Transcribed Image Text:Given the two relations, R1 and R2 Relation R1: Name Empld DeptName Harry 3415 Finance Sally 2241 Sales George 3401 Finance Harriet 2202 Sales Pim 5678 Advertizing Relation R2 DeptName Manager Finance George Sales Harriet Production Charles How many rows will be in the table of R1 LEFT OUTER JOIN R2? 3 O 2 4
The instructor relation
ID
Name Dept_name Salary
10101 Hayley Comp.Sci. 65000
12121 Jackson Finance
90000
15151 Nathan Music
87000
22222 April Biology
73000
34345 Crick Comp.Sci. 100000
The course relation
Course_id Title
Dept_name Credits
CS-101 Robotics
Comp.Sci. 5
BIO-244 Genetics
Biology
4
PHY-333 Physical Principles
Physics
3
MUS-562 Music Video Production Music
2
FIN-101 Investment Banking
Finance
3
Suppose the Authority want to include a new instructor for the title Neuroscience what command should be inserted ?
O Insert into course values(12111.Emma,NeuroScience, 200000);
O Insert into instructor values(12111,Emma,NeuroScience, 200000);
Insert into course values(12111,Introduction, NeuroScience, 2):
Insert into instructor values(12111,Emma, Biology,200000);
Transcribed Image Text:The instructor relation ID Name Dept_name Salary 10101 Hayley Comp.Sci. 65000 12121 Jackson Finance 90000 15151 Nathan Music 87000 22222 April Biology 73000 34345 Crick Comp.Sci. 100000 The course relation Course_id Title Dept_name Credits CS-101 Robotics Comp.Sci. 5 BIO-244 Genetics Biology 4 PHY-333 Physical Principles Physics 3 MUS-562 Music Video Production Music 2 FIN-101 Investment Banking Finance 3 Suppose the Authority want to include a new instructor for the title Neuroscience what command should be inserted ? O Insert into course values(12111.Emma,NeuroScience, 200000); O Insert into instructor values(12111,Emma,NeuroScience, 200000); Insert into course values(12111,Introduction, NeuroScience, 2): Insert into instructor values(12111,Emma, Biology,200000);
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr