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

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.

Extracted 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


Extracted 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