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.

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

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx and Solution.docx.

    for this solution

    or FREE if you
    register a new account!

    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.

    Upload a file
    Continue without uploading

    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