Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Question: Which colleges offer courses?    (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE

Question: Which colleges offer courses?    (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE

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

Question: Which colleges offer courses?   

(Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  **

SELECT COURSE.COLLEGE

FROM COURSE, DEPARTMENT

WHERE COURSE.DCODE = DEPARTMENT.DCODE;

**The DATABASE PDF** ### DEPARTMENT Relation | NAME | DCODE | COLLEGE | PHONE | LOCATION | HODID | |-------------|-------|---------------------|-----------|----------------|---------| | Economics | 1 | Arts and Sciences | 5235567654| 123 McMicken | FM49276 | | QA/QM | 3 | Business | 5235566566| 333 Lindner | BA54325 | | Economics | 4 | Education | 5235569879| 336 Dyer | CM65436 | | Mathematics | 6 | Engineering | 5235564379| 728 Old Chem | RR79345 | | IS | 7 | Business | 5235567489| 333 Lindner | CC49234 | | Philosophy | 9 | Arts and Sciences | 5235565546| 272 McMicken | CM87659 | ### COURSE Relation | NAME | COURSE# | CREDIT | COLLEGE | HRS | DCODE | |---------------------------------|---------|--------|-----------|-----|-------| | Intro to Economics | 15ECON112 | U | Arts and Sciences | 3 | 1 | | Operations Research | 22QA375 | U | Business | 2 | 3 | | Intro to Economics | 18ECON123 | U | Education | 4 | 4 | | Supply Chain Analysis | 22QA411 | U | Business | 3 | 3 | | Principles of IS | 22IS270 | G | Business | 3 | 7 | | Programming in C++ | 20ECSE212 | G | Engineering | 3 | 6 | | Optimization | 22QA888 | G | Business | 3 | 3 | | Financial Accounting | 18ACCT801 | G | Education | 3 | 4 | | Database Concepts | 22IS330 | U | Business | 4 | 7 | | Database Principles | 22IS832 | G | Business | 3 |
Transcribed Image Text:**The DATABASE PDF** ### DEPARTMENT Relation | NAME | DCODE | COLLEGE | PHONE | LOCATION | HODID | |-------------|-------|---------------------|-----------|----------------|---------| | Economics | 1 | Arts and Sciences | 5235567654| 123 McMicken | FM49276 | | QA/QM | 3 | Business | 5235566566| 333 Lindner | BA54325 | | Economics | 4 | Education | 5235569879| 336 Dyer | CM65436 | | Mathematics | 6 | Engineering | 5235564379| 728 Old Chem | RR79345 | | IS | 7 | Business | 5235567489| 333 Lindner | CC49234 | | Philosophy | 9 | Arts and Sciences | 5235565546| 272 McMicken | CM87659 | ### COURSE Relation | NAME | COURSE# | CREDIT | COLLEGE | HRS | DCODE | |---------------------------------|---------|--------|-----------|-----|-------| | Intro to Economics | 15ECON112 | U | Arts and Sciences | 3 | 1 | | Operations Research | 22QA375 | U | Business | 2 | 3 | | Intro to Economics | 18ECON123 | U | Education | 4 | 4 | | Supply Chain Analysis | 22QA411 | U | Business | 3 | 3 | | Principles of IS | 22IS270 | G | Business | 3 | 7 | | Programming in C++ | 20ECSE212 | G | Engineering | 3 | 6 | | Optimization | 22QA888 | G | Business | 3 | 3 | | Financial Accounting | 18ACCT801 | G | Education | 3 | 4 | | Database Concepts | 22IS330 | U | Business | 4 | 7 | | Database Principles | 22IS832 | G | Business | 3 |
### Madeira College Relations: A Database Example #### Employee Relation | Name | EID | SSN | DOB | DNO | Salary | |-------------|---------|-----------|----------|-----|--------| | Ram Raj | RR79345 | 5235567244| 23-JUN-01| 6 | 44000 | | John B Smith| SI65436 | 5235567556| 25-JUL-71| 5 | 53000 | | Prester John | JP77869 | 5235567244| 25-AUG-95| 6 | 44000 | | Chelsea Bush| BC65437 | 5235567244| 01-MAY-73| 5 | 70000 | | Tony Hopkins| HT54347 | 5235567997| 10-JAN-97| 3 | 73000 | | Alan Brodie | AB45875 | 5235569874| 10-MAY-90| 7 | 76000 | | Jessica Simpson| SI67543 | 5235565677| 25-JUN-96| 5 | 67000 | | Laura Jackson| LJ65436 | 5235565436| 23-SEP-09| 3 | 76000 | | Marie Curie | CM65436 | 5235566898| 29-DEC-97| 6 | 74000 | | Jack Nicklaus| NI35433 | 5235566767| 31-DEC-99| 4 | 69000 | | John Nicholson| NA47882 | 5235566999| 22-JUN-03| 3 | 47000 | | Sunil Shetty| SK43278 | 5235566764| 28-JUN-93| 7 | 64000 | | Katie Shef | SK85977 | 5235567435| 19-DEC-95| 8 | 69000 | | Cathy Cobal | CC49234 | 5235565345| 23-JAN-01| 7 | 45000 | | Jeanine Troy| TJ76546 | 5235565455| 02-MAY-02|
Transcribed Image Text:### Madeira College Relations: A Database Example #### Employee Relation | Name | EID | SSN | DOB | DNO | Salary | |-------------|---------|-----------|----------|-----|--------| | Ram Raj | RR79345 | 5235567244| 23-JUN-01| 6 | 44000 | | John B Smith| SI65436 | 5235567556| 25-JUL-71| 5 | 53000 | | Prester John | JP77869 | 5235567244| 25-AUG-95| 6 | 44000 | | Chelsea Bush| BC65437 | 5235567244| 01-MAY-73| 5 | 70000 | | Tony Hopkins| HT54347 | 5235567997| 10-JAN-97| 3 | 73000 | | Alan Brodie | AB45875 | 5235569874| 10-MAY-90| 7 | 76000 | | Jessica Simpson| SI67543 | 5235565677| 25-JUN-96| 5 | 67000 | | Laura Jackson| LJ65436 | 5235565436| 23-SEP-09| 3 | 76000 | | Marie Curie | CM65436 | 5235566898| 29-DEC-97| 6 | 74000 | | Jack Nicklaus| NI35433 | 5235566767| 31-DEC-99| 4 | 69000 | | John Nicholson| NA47882 | 5235566999| 22-JUN-03| 3 | 47000 | | Sunil Shetty| SK43278 | 5235566764| 28-JUN-93| 7 | 64000 | | Katie Shef | SK85977 | 5235567435| 19-DEC-95| 8 | 69000 | | Cathy Cobal | CC49234 | 5235565345| 23-JAN-01| 7 | 45000 | | Jeanine Troy| TJ76546 | 5235565455| 02-MAY-02|
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Intermediate SQL concepts
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
  • SEE MORE 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