Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
press the following SQL code in Relational Algebra form. SELECT * FROM COURSE WHERE (COURSE.COLLEGE <> ’Business’ OR COURSE.COLLEGE <> ’Engineering’) AND COURSE.CREDIT = ’U’;

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

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

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

**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++ | 20ECE5212| 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 |
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++ | 20ECE5212| 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 |
The image contains a set of relational data tables related to Madeira College. Each table represents different entities and their relationships. Below is a detailed transcription and explanation of each table. ### Employee Relation This table contains information about employees, including their ID, social security number, hire date, department, and salary. - **Ram Raj**: ID (RR7934), SSN (5235567244), Hire Date (23-JUN-01), Dept (6), Salary (44000) - **John B Smith**: ID (SI65346), SSN (5235567556), Hire Date (01-MAY-94), Dept (3), Salary (55000) - **Prester John**: ID (JP77869), SSN (5235567244), Hire Date (25-AUG-95), Dept (6), Salary (44000) - **Chelsea Bush**: ID (BC65437), SSN (5235567441), Hire Date (01-MAY-94), Dept (3), Salary (60000) - **Tony Hopkins**: ID (HT54347), SSN (5235566790), Hire Date (10-NOV-97), Dept (3), Salary (77000) - **Alan Brodie**: ID (AB57435), SSN (5235569874), Hire Date (16-OCT-91), Dept (3), Salary (76000) - **Jessica Simpson**: ID (SI67543), SSN (5235566577), Hire Date (23-JUN-06), Dept (5), Salary (67000) - **Laura Jackson**: ID (LJ65436), SSN (5235565436), Hire Date (23-SEP-09), Dept (3), Salary (67000) - **Marie Curie**: ID (MC56436), SSN (5235562989), Hire Date (29-APR-08), Dept (4), Salary (65000) - **Jack Nicklaus**: ID (NJ35533), SSN (5235566767), Hire Date (31-DEC-99), Dept (4), Salary (67000) - **John Nicholson**: ID (AJ48232), SSN (5235566999), Hire Date (22-JUN-04), Dept (7), Salary (60000) - **Sunil Shetty**: ID (SH43278), SS
Transcribed Image Text:The image contains a set of relational data tables related to Madeira College. Each table represents different entities and their relationships. Below is a detailed transcription and explanation of each table. ### Employee Relation This table contains information about employees, including their ID, social security number, hire date, department, and salary. - **Ram Raj**: ID (RR7934), SSN (5235567244), Hire Date (23-JUN-01), Dept (6), Salary (44000) - **John B Smith**: ID (SI65346), SSN (5235567556), Hire Date (01-MAY-94), Dept (3), Salary (55000) - **Prester John**: ID (JP77869), SSN (5235567244), Hire Date (25-AUG-95), Dept (6), Salary (44000) - **Chelsea Bush**: ID (BC65437), SSN (5235567441), Hire Date (01-MAY-94), Dept (3), Salary (60000) - **Tony Hopkins**: ID (HT54347), SSN (5235566790), Hire Date (10-NOV-97), Dept (3), Salary (77000) - **Alan Brodie**: ID (AB57435), SSN (5235569874), Hire Date (16-OCT-91), Dept (3), Salary (76000) - **Jessica Simpson**: ID (SI67543), SSN (5235566577), Hire Date (23-JUN-06), Dept (5), Salary (67000) - **Laura Jackson**: ID (LJ65436), SSN (5235565436), Hire Date (23-SEP-09), Dept (3), Salary (67000) - **Marie Curie**: ID (MC56436), SSN (5235562989), Hire Date (29-APR-08), Dept (4), Salary (65000) - **Jack Nicklaus**: ID (NJ35533), SSN (5235566767), Hire Date (31-DEC-99), Dept (4), Salary (67000) - **John Nicholson**: ID (AJ48232), SSN (5235566999), Hire Date (22-JUN-04), Dept (7), Salary (60000) - **Sunil Shetty**: ID (SH43278), SS
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
Table
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
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