Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Compute the average number of hours for the courses offered by each college

Compute the average number of hours for the courses offered by each college

Fundamentals of Information Systems
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Big Data
Section: Chapter Questions
Problem 16SAT
See similar textbooks
icon
Related questions
Question

Question: Compute the average number of hours for the courses offered by each college.  

(Answer should be a relational algebra query.) Please show the output based on your answer as well in a table for further explanation.  

SID NAME ADDRESS BIRTHDATE GRADELEVEL The DATABASE PDF BE76598 Elijah Baley 2920 Scioto Street JR OD76578 Daniel Olive 338 Bishop Street 12-MAY-82 JR SW56547 Wanda Seldon 3138 Probasco 03-MAR-70 FR DEPARTMENT Relation HG66765 Gladis Bale 356 Vine Street 23-ОСТ-77 FR NAME COLLEGE LOCATION Shweta Gupta 356 Probasco 21-MAY-79 DCODE PHONE HODID GS76775 SO Economics 1 Arts and 5235567654 123 McMicken FM49276 НТ67657 Troy Hudson JR Sciences FR45545 Rick Fox 314 Clifton 09-ОСТ-83 GR QA/QM FV67733 Vanessa Fox 314 Clifton 20-ОСТ-83 SO 3 Business 5235566656 333 Lindner BA54325 HJ45633 Jenna Hopp 2930 Scioto Street 03-MAR-70 SO Economics 4 Education 5235569978 336 Dyer CM65436 SD23556 David Sane 245 University 14-JUL-84 SR Mathematics 6. Engineering 5235564379 728 Old Chem RR79345 Avenue IS 7 Business 5235567489 333 Lindner CC49234 DT87656 Tim Duncan 21-MAY-75 SR Philosophy 9. Arts and 5235565546 272 Mcmicken CM87659 KJ56656 Joumana Kidd 2920 Scioto Street FR Sciences AJ76998 Jenny Aniston 88 Milk SR KP78924 Poppy Kramer 437 Love Lane 11-NOV-80 JR COURSE Relation KS39874 Sweety Kramer 748 Hope Avenue 2920 Scioto Street 20-FEB-76 11-NOV-80 JR JD35477 Diana Jackson GR NAME COURSE# CREDIT COLLEGE HRS DCODE Intro to 15ECON112 Arts and 3 1 Economics Sciences SECTION Relation Operations 22QA375 Business 2 SECTION# TIME MAXST ROOM COURSE# PROFID Research Education 101A2014 T1015 25 22QA375 HT54347 Intro to 18ECON123 4 4 901A2013 W1800 35 Rhodes 611 221S270 SK85977 Economics Supply Chain Analysis Principles of IS 22IS270 902A2013 H1700 25 Lindner 108 221S270 SK85977 22QA411 Business 3 3 20152013 T1045 29 Lindner 110 22IS330 SK85977 301S2013 H1045 29 Lindner 110 22IS330 CC49234 G Business 3 7 401W2014 M1000 33 Braunstien 211 22IS832 CC49234 Programming in C++ 2DECES212 Engineering 3 6 102A2014 W1800 Baldwin 437 20ECES212 RR79345 103U2014 T1015 33 22QA375 HT54347 Optimization 22QA888 Business 3 3 Financial 18ACСТ801 Education 4 104A2014 H1700 29 Lindner 108 221S330 SK85977 Accounting 10552014 T1015 30 22QA375 HT54347 Database 221S330 Business 4 7 106W2014 T1015 20 22QA375 HT54347 Concepts Database 221S832 G Business 3 7 Principles Madeira College relations Systems 2215430 Business 7 Analysis Architectural PROFESSOR Relation O5ARCH101 3 NAME John Smith Mike Faraday EMPID PHONE DATEHIRED DCODE SALARY History SJ89324 5235567645 23-JUN-01 45000 FM49276 5235568492 01-MAY-96 1 92000 STUDENT Relation Kobe Bryant BK68765 5235568522 01-MAY-98 1 66000
Transcribed Image Text:SID NAME ADDRESS BIRTHDATE GRADELEVEL The DATABASE PDF BE76598 Elijah Baley 2920 Scioto Street JR OD76578 Daniel Olive 338 Bishop Street 12-MAY-82 JR SW56547 Wanda Seldon 3138 Probasco 03-MAR-70 FR DEPARTMENT Relation HG66765 Gladis Bale 356 Vine Street 23-ОСТ-77 FR NAME COLLEGE LOCATION Shweta Gupta 356 Probasco 21-MAY-79 DCODE PHONE HODID GS76775 SO Economics 1 Arts and 5235567654 123 McMicken FM49276 НТ67657 Troy Hudson JR Sciences FR45545 Rick Fox 314 Clifton 09-ОСТ-83 GR QA/QM FV67733 Vanessa Fox 314 Clifton 20-ОСТ-83 SO 3 Business 5235566656 333 Lindner BA54325 HJ45633 Jenna Hopp 2930 Scioto Street 03-MAR-70 SO Economics 4 Education 5235569978 336 Dyer CM65436 SD23556 David Sane 245 University 14-JUL-84 SR Mathematics 6. Engineering 5235564379 728 Old Chem RR79345 Avenue IS 7 Business 5235567489 333 Lindner CC49234 DT87656 Tim Duncan 21-MAY-75 SR Philosophy 9. Arts and 5235565546 272 Mcmicken CM87659 KJ56656 Joumana Kidd 2920 Scioto Street FR Sciences AJ76998 Jenny Aniston 88 Milk SR KP78924 Poppy Kramer 437 Love Lane 11-NOV-80 JR COURSE Relation KS39874 Sweety Kramer 748 Hope Avenue 2920 Scioto Street 20-FEB-76 11-NOV-80 JR JD35477 Diana Jackson GR NAME COURSE# CREDIT COLLEGE HRS DCODE Intro to 15ECON112 Arts and 3 1 Economics Sciences SECTION Relation Operations 22QA375 Business 2 SECTION# TIME MAXST ROOM COURSE# PROFID Research Education 101A2014 T1015 25 22QA375 HT54347 Intro to 18ECON123 4 4 901A2013 W1800 35 Rhodes 611 221S270 SK85977 Economics Supply Chain Analysis Principles of IS 22IS270 902A2013 H1700 25 Lindner 108 221S270 SK85977 22QA411 Business 3 3 20152013 T1045 29 Lindner 110 22IS330 SK85977 301S2013 H1045 29 Lindner 110 22IS330 CC49234 G Business 3 7 401W2014 M1000 33 Braunstien 211 22IS832 CC49234 Programming in C++ 2DECES212 Engineering 3 6 102A2014 W1800 Baldwin 437 20ECES212 RR79345 103U2014 T1015 33 22QA375 HT54347 Optimization 22QA888 Business 3 3 Financial 18ACСТ801 Education 4 104A2014 H1700 29 Lindner 108 221S330 SK85977 Accounting 10552014 T1015 30 22QA375 HT54347 Database 221S330 Business 4 7 106W2014 T1015 20 22QA375 HT54347 Concepts Database 221S832 G Business 3 7 Principles Madeira College relations Systems 2215430 Business 7 Analysis Architectural PROFESSOR Relation O5ARCH101 3 NAME John Smith Mike Faraday EMPID PHONE DATEHIRED DCODE SALARY History SJ89324 5235567645 23-JUN-01 45000 FM49276 5235568492 01-MAY-96 1 92000 STUDENT Relation Kobe Bryant BK68765 5235568522 01-MAY-98 1 66000
Ram Raj RR79345 5235567244 23-JUN-01 6 44000 401W2014 A KS39874 John B Smith SJ65436 5235567556 6 104A2014 A BE76598 Prester John Chelsea Bush JP77869 5235567244 25-AUG-95 6. 44000 401W2014 B BG66765 ВС65437 5235567777 01-MAY-93 3 77000 104A2014 GS76775 Tony Hopkins Alan Brodie HT54347 5235569977 20-JAN-97 3 77000 BA54325 5235569876 16-MAY-00 3 76000 USES Relation Jessica Simpson SJ67543 5235565567 25-AUG-95 3 67000 Laura Jackson JL65436 5235565436 23-SEP-00 3 43000 COURSE# ISBN EMPID Marie Curie CM65436 5235569899 22-ОСТ-99 4 99000 1НЕCON123 0296748-99 CM65436 Jack Nicklaus NJ33533 5235566767 31-DEC-99 4 67000 2DECES212 0296437-1118 CC49234 John Nicholson NJ43728 5235569999 22-JUN-03 4 99000 22IS270 000-66574998 SS43278 Sunil Shetty 5235566764 SS43278 28-JUN-93 7 64000 22IS270 77898-8769 СС49234 Katie Shef SK85977 5235568765 06-JUN-97 7 65000 22IS270 77898-8769 SK85977 Cathy Cobal CC49234 5235565345 23-JAN-01 7 45000 22IS270 77898-8769 SS43278 Jeanine Troy TJ76546 5235565545 9 45000 22IS330 003-6679233 ВС65437 Tiger Woods WT65487 5235565563 14-NOV-03 9 22IS330 118-99898-67 SS43278 Mike Crick 5235565569 CM87659 30-MAY-02 9 69000 22IS832 000-66574998 SS43278 | 22IS832 | 22QA375 118- 99898-67 SK85977 0296437-1118 SJ65436 TEXTBOOK Relation | 22QAH88 001-55-435 HT54347 ISBN YEAR PUBLISHER TITLE Database Management 2007 000-66574998 Thomson Prentice-Hall Madeira College relations (continued) 003-6679233 Linear Programming 2005 001-55-435 Simulation Modeling 2009 Springer | 118-99898-67 Systems Analysis 2008 Thomson 77898-8769 Principles of IS 2010 Prentice-Hall 0296748-95 Economics For 2009 Managers Programming in C++ Fundamentals of SQL. 0296437-1118 2010 Thomson 012-54765-32 2012 111-11111111 Data Modeling 2013 TAKES Relation SECTION# GRADE SID 101A2014 A KP78924 101A2014 A KS39874 101A2014 B BG66765 201S2013 BE76598 104A2014 B KJ56656 104A2014 A KP78924 104A2014 A KS39874
Transcribed Image Text:Ram Raj RR79345 5235567244 23-JUN-01 6 44000 401W2014 A KS39874 John B Smith SJ65436 5235567556 6 104A2014 A BE76598 Prester John Chelsea Bush JP77869 5235567244 25-AUG-95 6. 44000 401W2014 B BG66765 ВС65437 5235567777 01-MAY-93 3 77000 104A2014 GS76775 Tony Hopkins Alan Brodie HT54347 5235569977 20-JAN-97 3 77000 BA54325 5235569876 16-MAY-00 3 76000 USES Relation Jessica Simpson SJ67543 5235565567 25-AUG-95 3 67000 Laura Jackson JL65436 5235565436 23-SEP-00 3 43000 COURSE# ISBN EMPID Marie Curie CM65436 5235569899 22-ОСТ-99 4 99000 1НЕCON123 0296748-99 CM65436 Jack Nicklaus NJ33533 5235566767 31-DEC-99 4 67000 2DECES212 0296437-1118 CC49234 John Nicholson NJ43728 5235569999 22-JUN-03 4 99000 22IS270 000-66574998 SS43278 Sunil Shetty 5235566764 SS43278 28-JUN-93 7 64000 22IS270 77898-8769 СС49234 Katie Shef SK85977 5235568765 06-JUN-97 7 65000 22IS270 77898-8769 SK85977 Cathy Cobal CC49234 5235565345 23-JAN-01 7 45000 22IS270 77898-8769 SS43278 Jeanine Troy TJ76546 5235565545 9 45000 22IS330 003-6679233 ВС65437 Tiger Woods WT65487 5235565563 14-NOV-03 9 22IS330 118-99898-67 SS43278 Mike Crick 5235565569 CM87659 30-MAY-02 9 69000 22IS832 000-66574998 SS43278 | 22IS832 | 22QA375 118- 99898-67 SK85977 0296437-1118 SJ65436 TEXTBOOK Relation | 22QAH88 001-55-435 HT54347 ISBN YEAR PUBLISHER TITLE Database Management 2007 000-66574998 Thomson Prentice-Hall Madeira College relations (continued) 003-6679233 Linear Programming 2005 001-55-435 Simulation Modeling 2009 Springer | 118-99898-67 Systems Analysis 2008 Thomson 77898-8769 Principles of IS 2010 Prentice-Hall 0296748-95 Economics For 2009 Managers Programming in C++ Fundamentals of SQL. 0296437-1118 2010 Thomson 012-54765-32 2012 111-11111111 Data Modeling 2013 TAKES Relation SECTION# GRADE SID 101A2014 A KP78924 101A2014 A KS39874 101A2014 B BG66765 201S2013 BE76598 104A2014 B KJ56656 104A2014 A KP78924 104A2014 A KS39874
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Payback period
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
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS