Use the given database to output the results of the following SQL queries: a.) SELECT DISTINCT C.building FROM Classroom AS C WHERE C.room number IN (SELECT S.room number FROM Section AS S WHERE S.time slot id = A);
Use the given database to output the results of the following SQL queries: a.) SELECT DISTINCT C.building FROM Classroom AS C WHERE C.room number IN (SELECT S.room number FROM Section AS S WHERE S.time slot id = A);
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
100%
Use the given
a.)
SELECT DISTINCT C.building
FROM Classroom AS C
WHERE C.room number IN
(SELECT S.room number
FROM Section AS S
WHERE S.time slot id = A);
![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%2F2677ee1a-a41f-404b-b90f-5e32ae36c1fc%2Fkcnk4gf_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
Transcribed Image Text:Packard
117% O |+| I
ab
3 /6 >
course id
sec id
semester
year
building
room.number
time slot id
BIO-101
1.
Summer
Summer
Fall
2009
2010
2009
2010
Painter
514
B
BIO-301
CS-101
CS-101
Painter
514
A
Packard
Packard
101
H
Spring
101
F
Spring
Spring
Spring
Spring
Spring
Fall
Spring
Spring
Spring
Spring
Fall
CS-190
Taylor
Taylor
Watson
2009
3128
E
CS-190
CS-315
CS-319
CS-319
CS-347
EE-181
FIN-201
HIS-351
2009
3128
2010
120
2010
Watson
100
Taylor
Taylor
Taylor
2010
3128
2009
3128
2009
3128
2010
101
Painter
Packard
2010
514
MU-199
2010
101
PHY-101
2009
Watson
100
A
Figure A.7 The section relation.
course id
sec id
semester
ID
year
10101
10101
10101
12121
15151
22222
32343
45565
45565
76766
CS-101
Fall
2009
2010
CS-315
1
Spring
Fall
CS-347
2009
Spring
Spring
Fall
FIN-201
2010
MU-199
2010
PHY-101
HIS-351
CS-101
CS-319
2009
Spring
Spring
Spring
Summer
Summer
2010
2010
2010
BIO-101
BIO-301
CS-190
CS-190
CS-319
2009
76766
83821
83821
2010
Spring
Spring
Spring
Spring
2009
2009
2010
2009
83821
98345
EE-181
Figure A.8 The feaches relation.
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 4 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