Use the given database to output the results of the following SQL queries: a.) SELECT building, room number, course id, prereq id FROM classroom, prereq;
Use the given database to output the results of the following SQL queries: a.) SELECT building, room number, course id, prereq id FROM classroom, prereq;
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 building, room number, course id, prereq id
FROM classroom, prereq;
![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%2F148e2896-22f9-4752-b3cf-aa7ffdf34183%2Feavtme_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
![6 /6 >
100% +
ab]
A.3 Sample Data
1281
course.id prereq id
BIO-301
BIO-101
BIO-399
BIO-101
CS-190
CS-101
CS-315
CS-101
CS-101
CS-319
CS-347
CS-101
PHY-101
EE-181
Figure A.13 The prereg relation.
time slot.id day | start hr
M
startmin
end hr
еndmin
A
8
8
50
W
8.
8
50
A
F
8
8
50
B
B
M
9
50
W
9
9
50
В
F
9.
9
50
M
11
11
50
50
11
11
F
11
11
50
13
13
50
W
13
13
50
F
13
13
50
E
T.
10
30
30
11
45
45
E
R
10
11
F
F
т
14
30
15
45
14
30
15
45
16
16
50
W
16
16
50
F
16
16
50
H.
W
10
12
30
Figure A.14 The timeslot relation with start and end time separated into hour and minute.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3532d2ef-d989-410d-a6cb-002f0a4a790e%2F148e2896-22f9-4752-b3cf-aa7ffdf34183%2Fzbckqdd_processed.png&w=3840&q=75)
Transcribed Image Text:6 /6 >
100% +
ab]
A.3 Sample Data
1281
course.id prereq id
BIO-301
BIO-101
BIO-399
BIO-101
CS-190
CS-101
CS-315
CS-101
CS-101
CS-319
CS-347
CS-101
PHY-101
EE-181
Figure A.13 The prereg relation.
time slot.id day | start hr
M
startmin
end hr
еndmin
A
8
8
50
W
8.
8
50
A
F
8
8
50
B
B
M
9
50
W
9
9
50
В
F
9.
9
50
M
11
11
50
50
11
11
F
11
11
50
13
13
50
W
13
13
50
F
13
13
50
E
T.
10
30
30
11
45
45
E
R
10
11
F
F
т
14
30
15
45
14
30
15
45
16
16
50
W
16
16
50
F
16
16
50
H.
W
10
12
30
Figure A.14 The timeslot relation with start and end time separated into hour and minute.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
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