Use the given database to output the results of the following SQL queries: b.) SELECT ∗ FROM course AS C INNERJOIN instructor AS I ON C.dept name = I.dept name WHERE I.ID = 45565; c.) SELECT dept name, building, name, ID FROM department LEFTJOIN instructor ON budget = salary;
Use the given database to output the results of the following SQL queries: b.) SELECT ∗ FROM course AS C INNERJOIN instructor AS I ON C.dept name = I.dept name WHERE I.ID = 45565; c.) SELECT dept name, building, name, ID FROM department LEFTJOIN instructor ON budget = salary;
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Use the given
b.)
SELECT ∗
FROM course AS C INNERJOIN instructor AS I ON C.dept name = I.dept name
WHERE I.ID = 45565;
c.)
SELECT dept name, building, name, ID
FROM department LEFTJOIN instructor ON budget = salary;
Transcribed Image Text:CS-101
FIN-201
2 /6 >
117% +
ab
course id
title
dept.name
credits
Intro. to Biology
Genetics
BIO-101
Biology
Biology
Biology
Comp. Sci.
Comp. Sci.
Comp. Sci.
Comp. Sci.
4
BIO-301
BIО-399
4.
Computational Biology
Intro. to Computer Science
3
4
CS-190
CS-315
CS-319
CS-347
EE-181
Game Design
Kobo
Robotics
Image Processing
Database System Concepts Comp. Sci.
Intro. to Digital Systems
Investment Banking
World History
Music Video Production
4
Elec. Eng.
EE-181
Finance
History
Music
Physics
HIS-351
MU-199
PHY-101
Physical Principles
4
Figure A.5 The course relation.
dept.name
salary
ID
name
Comp. Si.
Finance
10101
Srinivasan
65000
12121
15151
90000
40000
Wu
Mozart
Music
Einstein
El
el Said
Gold
Katz
Califieri
Physics
History
Physics
Comp. Sci.
History
Finance
95000
60000
87000
75000
62000
80000
72000
92000
80000
22222
32343
S2543
33456
45565
58583
76543
76766
83821
98345
Singh
Crick
Brandt
Biology
Comp. Sci.
Elec. Eng.
Kim
Figure A.6 The instructor relation.
![1 /6 >
100% +
ab]
In this section we provide sample data for each of the relations defined in the
previous section.
building room.number capacity
Packard
101
500
Painter
514
10
Taylor
Watson
Watson
3128
100
70
30
120
50
Figure A.3 The classroom relation.
dept.name
building budget
Biology
Watson
90000
Comp. Sci.
Taylor
100000
85000
Elec. Eng. Taylor
Finance
Painter
120000
History
Music
Physics
Painter
50000
Packard
Watson
80000
70000
Figure A.4 The department relation.
A.3 Sample Data
1277
title
dept.name
course.id
credits
BIO-101 Intro. to Biology
Biology
Biology
Biology
4
Genetics
Computational Biology
Intro. to Computer Science Comp. Sci.
Game Design
BIO-301
ВIО-399
4
3
CS-101
4
CS-190
Comp. Sci
4](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3532d2ef-d989-410d-a6cb-002f0a4a790e%2Fb598175a-0fc8-4475-bd15-324bbaa33703%2Fcj4gb6d_processed.png&w=3840&q=75)
Transcribed Image Text:1 /6 >
100% +
ab]
In this section we provide sample data for each of the relations defined in the
previous section.
building room.number capacity
Packard
101
500
Painter
514
10
Taylor
Watson
Watson
3128
100
70
30
120
50
Figure A.3 The classroom relation.
dept.name
building budget
Biology
Watson
90000
Comp. Sci.
Taylor
100000
85000
Elec. Eng. Taylor
Finance
Painter
120000
History
Music
Physics
Painter
50000
Packard
Watson
80000
70000
Figure A.4 The department relation.
A.3 Sample Data
1277
title
dept.name
course.id
credits
BIO-101 Intro. to Biology
Biology
Biology
Biology
4
Genetics
Computational Biology
Intro. to Computer Science Comp. Sci.
Game Design
BIO-301
ВIО-399
4
3
CS-101
4
CS-190
Comp. Sci
4
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education