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


Express the following SQL code in Relational Algebra form.
SELECT *
FROM COURSE
WHERE (COURSE.COLLEGE <> ’Business’
OR COURSE.COLLEGE <> ’Engineering’)
AND COURSE.CREDIT = ’U’;


SID<br>NAME<br>ADDRESS<br>BIRTHDATE<br>GRADELEVEL<br>The DATABASE PDF<br>BE76598<br>Elijah Baley<br>2920 Scioto Street<br>JR<br>OD76578<br>Daniel Olive<br>338 Bishop Street<br>12-MAY-82<br>JR<br>SW56547<br>Wanda Seldon<br>3138 Probasco<br>03-MAR-70<br>FR<br>DEPARTMENT Relation<br>HG66765<br>Gladis Bale<br>356 Vine Street<br>23-ОСТ-77<br>FR<br>NAME<br>COLLEGE<br>LOCATION<br>Shweta Gupta<br>356 Probasco<br>21-MAY-79<br>DCODE<br>PHONE<br>HODID<br>GS76775<br>SO<br>Economics<br>1<br>Arts and<br>5235567654<br>123 McMicken FM49276<br>НТ67657<br>Troy Hudson<br>JR<br>Sciences<br>FR45545<br>Rick Fox<br>314 Clifton<br>09-ОСТ-83<br>GR<br>QA/QM<br>FV67733<br>Vanessa Fox<br>314 Clifton<br>20-ОСТ-83<br>SO<br>3<br>Business<br>5235566656<br>333 Lindner<br>BA54325<br>HJ45633<br>Jenna Hopp<br>2930 Scioto Street 03-MAR-70<br>SO<br>Economics<br>4<br>Education<br>5235569978<br>336 Dyer<br>CM65436<br>SD23556<br>David Sane<br>245 University<br>14-JUL-84<br>SR<br>Mathematics<br>6.<br>Engineering<br>5235564379<br>728 Old Chem<br>RR79345<br>Avenue<br>IS<br>7<br>Business<br>5235567489<br>333 Lindner<br>CC49234<br>DT87656<br>Tim Duncan<br>21-MAY-75<br>SR<br>Philosophy<br>9.<br>Arts and<br>5235565546<br>272 Mcmicken<br>CM87659<br>KJ56656<br>Joumana Kidd<br>2920 Scioto Street<br>FR<br>Sciences<br>AJ76998<br>Jenny Aniston<br>88 Milk<br>SR<br>KP78924<br>Poppy Kramer<br>437 Love Lane<br>11-NOV-80<br>JR<br>COURSE Relation<br>KS39874<br>Sweety Kramer<br>748 Hope Avenue<br>2920 Scioto Street 20-FEB-76<br>11-NOV-80<br>JR<br>JD35477<br>Diana Jackson<br>GR<br>NAME<br>COURSE#<br>CREDIT<br>COLLEGE<br>HRS<br>DCODE<br>Intro to<br>15ECON112<br>Arts and<br>3<br>1<br>Economics<br>Sciences<br>SECTION Relation<br>Operations<br>22QA375<br>Business<br>2<br>SECTION#<br>TIME<br>MAXST<br>ROOM<br>COURSE#<br>PROFID<br>Research<br>Education<br>101A2014<br>T1015<br>25<br>22QA375<br>HT54347<br>Intro to<br>18ECON123<br>4<br>4<br>901A2013<br>W1800<br>35<br>Rhodes 611<br>221S270<br>SK85977<br>Economics<br>Supply Chain<br>Analysis<br>Principles of IS 22IS270<br>902A2013<br>H1700<br>25<br>Lindner 108<br>221S270<br>SK85977<br>22QA411<br>Business<br>3<br>3<br>20152013<br>T1045<br>29<br>Lindner 110<br>22IS330<br>SK85977<br>301S2013<br>H1045<br>29<br>Lindner 110<br>22IS330<br>CC49234<br>G<br>Business<br>3<br>7<br>401W2014<br>M1000<br>33<br>Braunstien 211<br>22IS832<br>CC49234<br>Programming<br>in C++<br>2DECES212<br>Engineering<br>3<br>6<br>102A2014<br>W1800<br>Baldwin 437<br>20ECES212<br>RR79345<br>103U2014<br>T1015<br>33<br>22QA375<br>HT54347<br>Optimization<br>22QA888<br>Business<br>3<br>3<br>Financial<br>18ACСТ801<br>Education<br>4<br>104A2014<br>H1700<br>29<br>Lindner 108<br>221S330<br>SK85977<br>Accounting<br>10552014<br>T1015<br>30<br>22QA375<br>HT54347<br>Database<br>221S330<br>Business<br>4<br>7<br>106W2014<br>T1015<br>20<br>22QA375<br>HT54347<br>Concepts<br>Database<br>221S832<br>G<br>Business<br>3<br>7<br>Principles<br>Madeira College relations<br>Systems<br>2215430<br>Business<br>7<br>Analysis<br>Architectural<br>PROFESSOR Relation<br>O5ARCH101<br>3<br>NAME<br>John Smith<br>Mike Faraday<br>EMPID<br>PHONE<br>DATEHIRED<br>DCODE<br>SALARY<br>History<br>SJ89324<br>5235567645<br>23-JUN-01<br>45000<br>FM49276<br>5235568492<br>01-MAY-96<br>1<br>92000<br>STUDENT Relation<br>Kobe Bryant<br>BK68765<br>5235568522<br>01-MAY-98<br>1<br>66000<br>

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
Ram Raj<br>RR79345<br>5235567244<br>23-JUN-01<br>6<br>44000<br>401W2014<br>A<br>KS39874<br>John B Smith<br>SJ65436<br>5235567556<br>6<br>104A2014<br>A<br>BE76598<br>Prester John<br>Chelsea Bush<br>JP77869<br>5235567244<br>25-AUG-95<br>6.<br>44000<br>401W2014<br>B<br>BG66765<br>ВС65437<br>5235567777<br>01-MAY-93<br>3<br>77000<br>104A2014<br>GS76775<br>Tony Hopkins<br>Alan Brodie<br>HT54347<br>5235569977<br>20-JAN-97<br>3<br>77000<br>BA54325<br>5235569876<br>16-MAY-00<br>3<br>76000<br>USES Relation<br>Jessica Simpson<br>SJ67543<br>5235565567<br>25-AUG-95<br>3<br>67000<br>Laura Jackson<br>JL65436<br>5235565436<br>23-SEP-00<br>3<br>43000<br>COURSE#<br>ISBN<br>EMPID<br>Marie Curie<br>CM65436<br>5235569899<br>22-ОСТ-99<br>4<br>99000<br>1НЕCON123<br>0296748-99<br>CM65436<br>Jack Nicklaus<br>NJ33533<br>5235566767<br>31-DEC-99<br>4<br>67000<br>2DECES212<br>0296437-1118<br>CC49234<br>John Nicholson<br>NJ43728<br>5235569999<br>22-JUN-03<br>4<br>99000<br>22IS270<br>000-66574998<br>SS43278<br>Sunil Shetty<br>5235566764<br>SS43278<br>28-JUN-93<br>7<br>64000<br>22IS270<br>77898-8769<br>СС49234<br>Katie Shef<br>SK85977<br>5235568765<br>06-JUN-97<br>7<br>65000<br>22IS270<br>77898-8769<br>SK85977<br>Cathy Cobal<br>CC49234<br>5235565345<br>23-JAN-01<br>7<br>45000<br>22IS270<br>77898-8769<br>SS43278<br>Jeanine Troy<br>TJ76546<br>5235565545<br>9<br>45000<br>22IS330<br>003-6679233<br>ВС65437<br>Tiger Woods<br>WT65487<br>5235565563<br>14-NOV-03<br>9<br>22IS330<br>118-99898-67<br>SS43278<br>Mike Crick<br>5235565569<br>CM87659<br>30-MAY-02<br>9<br>69000<br>22IS832<br>000-66574998<br>SS43278<br>| 22IS832<br>| 22QA375<br>118- 99898-67<br>SK85977<br>0296437-1118<br>SJ65436<br>TEXTBOOK Relation<br>| 22QAH88<br>001-55-435<br>HT54347<br>ISBN<br>YEAR<br>PUBLISHER<br>TITLE<br>Database Management 2007<br>000-66574998<br>Thomson<br>Prentice-Hall<br>Madeira College relations (continued)<br>003-6679233<br>Linear Programming<br>2005<br>001-55-435<br>Simulation Modeling<br>2009<br>Springer<br>| 118-99898-67<br>Systems Analysis<br>2008<br>Thomson<br>77898-8769<br>Principles of IS<br>2010<br>Prentice-Hall<br>0296748-95<br>Economics For<br>2009<br>Managers<br>Programming in C++<br>Fundamentals of SQL.<br>0296437-1118<br>2010<br>Thomson<br>012-54765-32<br>2012<br>111-11111111<br>Data Modeling<br>2013<br>TAKES Relation<br>SECTION#<br>GRADE<br>SID<br>101A2014<br>A<br>KP78924<br>101A2014<br>A<br>KS39874<br>101A2014<br>B<br>BG66765<br>201S2013<br>BE76598<br>104A2014<br>B<br>KJ56656<br>104A2014<br>A<br>KP78924<br>104A2014<br>A<br>KS39874<br>

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
Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here