QuestionQuestion

For each problem you are expected to produce a relational algebra expression or set of expressions to produce the results. You are also required to show the exact results of the Relational Algebra query. Microsoft Excel is suggested.
You may use intermediate storage {TEMP <--- σ<c2>(R)}
Note: All problems can be completed using one table in your relational algebra expression.

Problem 1
List the name and project number of all projects controlled by Department 4.

Problem 2
List the last name, sex, and salary of all the males making more than $25000.

Problem 3
List all the female spouses (first name and birth date ) who are more than 40 years old.

Problem 4
List all employees (last name and birth date) who are either who are either less than 50 or greater than 65 as of 1/1/15.

Problem 5
List the department numbers whose location is not Houston.

Problem 86
List the managers (Mgr_ssn, Dname, and start date) for those managers who started more than 25 years ago.

Problem7
Using the union operation, write a relational algebra expression to list employees (last name and salary) earning less than $30,000 or more than $50,000.

Problem 8
Repeat problem 7 using nested relational algebra (Format: σ <c1>(σ<c2>(R))

Problem 9
Using the intersection statement, write a relational algebra expression to list all employees making more than $25,000 and less than $42,000 and were also born in the 1960s.

Problem 10
Repeat problem 9 using nested relational algebra.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Relational Algebra Database Problems
    $60.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats