Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
4. Which colleges offer courses? 5. What is the name and college of each department? 6. What is the product of the DEPARTMENT and COURSE relations?

4. Which colleges offer courses? 5. What is the name and college of each department? 6. What is the product of the DEPARTMENT and COURSE relations?

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

Find the relation algebra query based on the SQL given. 

DEPARTMENT Relation PROFES SOR Relation NAME DCODE COLLEGE PHONE LOCAT ION HODID NAME EMPID PHONE DATEH IRED DCODE SALARY 1 Arta and Sciences 5235567654 123 MaMicken 3 Husiness 4 Educat ion 6 Engi neering 7 Business 9 Arts and Sciences 52355655 46 272 Maticken FM4 9276 RAS 4325 John Smith Mike Faraday Kobe Bryant Ram Raj John Smith 5235567645 23-JUN-D1 5235568492 01-MAY-96 5235568522 01-MAY-98 Economi cs SJ89324 45000 92000 66000 5235566656 333 Lindner FM49276 52355699 78 336 Dyer CMG54 36 RR7 9345 cC4 9234 CMB 7659 Economics EKE8765 Mathematics 5235564379 728. Old Chem FR79345 5235567244 23-JUN-G1 44000 SJ65436 JP77869 IS 5235567489 333 Lindner 5235567556 Phi losophy Prester John 5235567244 25-AUG-95 44D00 Chelsea Bush BC65437 5235567777 01-MAY-93 77000 COURSE Relation 5235569977 20-JAN-97 BAS4325 S225569876 16-MAY-00 5235565567 25-AUG-95 5235565436 23-SEP-00 Tony Hopkins #T54347 77000 COURSE DOODE NAME CREDIT COLLEGE HRS Alan Brodie 76000 Jessica Simpson SJ67543 JL65436 67000 15KCON112 U 22QA375 Intro to Economies Arta and Saiencen Laura Jackson 43000 Ope rations Resear ch Intro to Econcmics Supply Chain Anal ysis 220A411 Principles of IS Programing in C++ Optimizstion Financial Account ing Database Concepts Database Principles Systems Analysis Archi tectural Ristory 0S ARCH101 U Rusiness Marie Curie CM65436 5235569899 22-OCT-99 4 99000 18 ECON123 U Educat ion 5235566767 31-DEC-99 5235569999 22-JUN-03 Jack Nicklaus NJ33533 67000 Rusiness 99000 64000 John Nicholson NJ43728 5235566764 28-JUN-93 523556876S 06-JUN-97 22IS270 Business Sunil Shetty Katie Shet Cathy Cobal Jeanine Troy Tigar Woods Mi ke Crick 5543278 20ECES212G Engineer ing Rusiness ロcation SKB5977 65000 220A 888 CC49234 5235565345 23-JAN-01 5235565545 45000 18ACCT 801 G TJ76546 45000 22 IS330 Rusiness WT65487 5235565563 14-NOV-03 22IS832 22 18430 Busi ness CMB 7659 5235565569 30-MAY-02 69000 Busi ness TEXTBOOK Relation TITLE YEAR PURLISHER ------------- ------ 2007 Thomson ISAN STUDENT Relation ---- -- SID NAKE ADDRESS BIRTHDATE GRADELEVEL D00-66574998 003-6679233 Database Management Linear Progranming Simulati on Modeling systems Analysia Principles of IS Economics For Managers Programm ing in C++ Fundamen tals of sot Data Modeling BE7 65 98 Elijah Raley OD765 78 Daniel Olive 2920 Scioto Street 338 Hi shop Street 31 38 Probasco JR 12-MAY-82 JR 03-MAR-70 FR 2005 Prentice-Hall 2009 Springer 2008 Thomson D01-55-43s 118-99898-67 77898-8769 SW5 6547 ands Seldon 2010 Prentice-Hall BGG6765 Gladis Bale 356 Vine Street 23-OCT-77 yR 029674 -99 2009 GS76775 Sharets Gupta HTG7657 Troy Hudson FR45545 Riek Fox 356 Probanoo 21-MAY-79 Sso 0296437-1118 2010 Thomnon JR 012-54765-32 2012 314 Clifton 314 clifton 2930 Sai oto St reet 245 Universi ty Avenue 14-JUL-84 SR 09-OCT-83 GR 20-OCT-83 So 03-MAR-70 so 111-11111111 2013 FV67733 Vanes sa Fox HJ45633 Jenna Hopp sn23556 David Sane DTB7656 Tim Duncan TAKES Relation SECTIONS GRADE SID 21-MAY-75 SR --- - -------- KJ56656 Joumana Kidd 2920 Scioto Street FR 101A2014 A KP78924 AJ76998 Jenny Ani ston 88 MLK KP78924 PoPpy Kramer ES3 9874 SMeety Kramer JD35477 Diana Jackson 2920 Scioto St reet SR 101A2014A KS39874 437 Love Lane 748 Hope Aventue 11-NOV-80 JR 101A2014 B BGE6765 11-NOV-80 JR 20152013 C 104A2014 B BE76598 20-FER-76 GR K756656 104A2014A KP78924 KS39874 SECTION Relation 104A2014 A SECTION TIM MAX ST ROOM COUR SE PROFID KS39874 BE76598 401W2014 A 104A2014 A 220A375 221s270 101A2014 T1015 25 HT5 4347 RG66765 GS76775 401W2014 B 901 A2013 KI B00 35 Rhodes 611 SKB5977 104A2014 C 902A2013 HI 700 25 Lindner 108 221S270 SKA5977 22 IS330 221S330 201 s2013 T1045 29 Lindner 110 SKB5977 USES Relation CC4 9234 cC4 9234 20ECES212 RR7 93 45 301s2013 HI045 29 Lindner 110 COURSE ISEN EMPID 401 W2014 I 000 33 Braunstien 211 22IS832 102A2014 WI B00 Haldwin 437 1HECON 123 0296748-99 20ECES 212 0296437-1118 2218270 CM65436 CC49234 103 U2014 TL015 33 HT54347 220A375 22IS330 220A375 220A375 SKA5977 HT5 4347 HT54347 104A2014 H1700 29 Lindner 108 000-66574998 S543278 CC49234 10582014 TI015 30 22I5270 77898-8769 106W2014 TI015 20 2215270 221S270 77898-8769 SKHS977 77898-8769 S543278 221533 0 003-6679233 BC65437 221533 0 22IS832 118-99898-67 D00-6657499 118-99898-67 S543278 S543278 Madeira College relations 2218832 220A375 220ARS SK95977 0296437-1118 001-55-435 SJ65436 HT54347 Madeira College relations (cotinued)
Transcribed Image Text:DEPARTMENT Relation PROFES SOR Relation NAME DCODE COLLEGE PHONE LOCAT ION HODID NAME EMPID PHONE DATEH IRED DCODE SALARY 1 Arta and Sciences 5235567654 123 MaMicken 3 Husiness 4 Educat ion 6 Engi neering 7 Business 9 Arts and Sciences 52355655 46 272 Maticken FM4 9276 RAS 4325 John Smith Mike Faraday Kobe Bryant Ram Raj John Smith 5235567645 23-JUN-D1 5235568492 01-MAY-96 5235568522 01-MAY-98 Economi cs SJ89324 45000 92000 66000 5235566656 333 Lindner FM49276 52355699 78 336 Dyer CMG54 36 RR7 9345 cC4 9234 CMB 7659 Economics EKE8765 Mathematics 5235564379 728. Old Chem FR79345 5235567244 23-JUN-G1 44000 SJ65436 JP77869 IS 5235567489 333 Lindner 5235567556 Phi losophy Prester John 5235567244 25-AUG-95 44D00 Chelsea Bush BC65437 5235567777 01-MAY-93 77000 COURSE Relation 5235569977 20-JAN-97 BAS4325 S225569876 16-MAY-00 5235565567 25-AUG-95 5235565436 23-SEP-00 Tony Hopkins #T54347 77000 COURSE DOODE NAME CREDIT COLLEGE HRS Alan Brodie 76000 Jessica Simpson SJ67543 JL65436 67000 15KCON112 U 22QA375 Intro to Economies Arta and Saiencen Laura Jackson 43000 Ope rations Resear ch Intro to Econcmics Supply Chain Anal ysis 220A411 Principles of IS Programing in C++ Optimizstion Financial Account ing Database Concepts Database Principles Systems Analysis Archi tectural Ristory 0S ARCH101 U Rusiness Marie Curie CM65436 5235569899 22-OCT-99 4 99000 18 ECON123 U Educat ion 5235566767 31-DEC-99 5235569999 22-JUN-03 Jack Nicklaus NJ33533 67000 Rusiness 99000 64000 John Nicholson NJ43728 5235566764 28-JUN-93 523556876S 06-JUN-97 22IS270 Business Sunil Shetty Katie Shet Cathy Cobal Jeanine Troy Tigar Woods Mi ke Crick 5543278 20ECES212G Engineer ing Rusiness ロcation SKB5977 65000 220A 888 CC49234 5235565345 23-JAN-01 5235565545 45000 18ACCT 801 G TJ76546 45000 22 IS330 Rusiness WT65487 5235565563 14-NOV-03 22IS832 22 18430 Busi ness CMB 7659 5235565569 30-MAY-02 69000 Busi ness TEXTBOOK Relation TITLE YEAR PURLISHER ------------- ------ 2007 Thomson ISAN STUDENT Relation ---- -- SID NAKE ADDRESS BIRTHDATE GRADELEVEL D00-66574998 003-6679233 Database Management Linear Progranming Simulati on Modeling systems Analysia Principles of IS Economics For Managers Programm ing in C++ Fundamen tals of sot Data Modeling BE7 65 98 Elijah Raley OD765 78 Daniel Olive 2920 Scioto Street 338 Hi shop Street 31 38 Probasco JR 12-MAY-82 JR 03-MAR-70 FR 2005 Prentice-Hall 2009 Springer 2008 Thomson D01-55-43s 118-99898-67 77898-8769 SW5 6547 ands Seldon 2010 Prentice-Hall BGG6765 Gladis Bale 356 Vine Street 23-OCT-77 yR 029674 -99 2009 GS76775 Sharets Gupta HTG7657 Troy Hudson FR45545 Riek Fox 356 Probanoo 21-MAY-79 Sso 0296437-1118 2010 Thomnon JR 012-54765-32 2012 314 Clifton 314 clifton 2930 Sai oto St reet 245 Universi ty Avenue 14-JUL-84 SR 09-OCT-83 GR 20-OCT-83 So 03-MAR-70 so 111-11111111 2013 FV67733 Vanes sa Fox HJ45633 Jenna Hopp sn23556 David Sane DTB7656 Tim Duncan TAKES Relation SECTIONS GRADE SID 21-MAY-75 SR --- - -------- KJ56656 Joumana Kidd 2920 Scioto Street FR 101A2014 A KP78924 AJ76998 Jenny Ani ston 88 MLK KP78924 PoPpy Kramer ES3 9874 SMeety Kramer JD35477 Diana Jackson 2920 Scioto St reet SR 101A2014A KS39874 437 Love Lane 748 Hope Aventue 11-NOV-80 JR 101A2014 B BGE6765 11-NOV-80 JR 20152013 C 104A2014 B BE76598 20-FER-76 GR K756656 104A2014A KP78924 KS39874 SECTION Relation 104A2014 A SECTION TIM MAX ST ROOM COUR SE PROFID KS39874 BE76598 401W2014 A 104A2014 A 220A375 221s270 101A2014 T1015 25 HT5 4347 RG66765 GS76775 401W2014 B 901 A2013 KI B00 35 Rhodes 611 SKB5977 104A2014 C 902A2013 HI 700 25 Lindner 108 221S270 SKA5977 22 IS330 221S330 201 s2013 T1045 29 Lindner 110 SKB5977 USES Relation CC4 9234 cC4 9234 20ECES212 RR7 93 45 301s2013 HI045 29 Lindner 110 COURSE ISEN EMPID 401 W2014 I 000 33 Braunstien 211 22IS832 102A2014 WI B00 Haldwin 437 1HECON 123 0296748-99 20ECES 212 0296437-1118 2218270 CM65436 CC49234 103 U2014 TL015 33 HT54347 220A375 22IS330 220A375 220A375 SKA5977 HT5 4347 HT54347 104A2014 H1700 29 Lindner 108 000-66574998 S543278 CC49234 10582014 TI015 30 22I5270 77898-8769 106W2014 TI015 20 2215270 221S270 77898-8769 SKHS977 77898-8769 S543278 221533 0 003-6679233 BC65437 221533 0 22IS832 118-99898-67 D00-6657499 118-99898-67 S543278 S543278 Madeira College relations 2218832 220A375 220ARS SK95977 0296437-1118 001-55-435 SJ65436 HT54347 Madeira College relations (cotinued)
4. Which colleges offer courses? 5. What is the name and college of each department? 6. What is the product of the DEPARTMENT and COURSE relations?
Transcribed Image Text:4. Which colleges offer courses? 5. What is the name and college of each department? 6. What is the product of the DEPARTMENT and COURSE relations?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
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
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