Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
Related questions
Question
100%

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);

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: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
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.
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
steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
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 System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS