Explore BrainMass

Explore BrainMass

    Relational Algebra

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    From the following relations, write the Relational Algebra to:

    Find the part(s) that have been supplied by more than one vendor during February.

    Vendors(vend#, vend_name, vend_phone)
    Parts(part#, part_desc, part_price)
    Supplys(vend#, part#, supply_date).

    © BrainMass Inc. brainmass.com March 4, 2021, 6:14 pm ad1c9bdddf
    https://brainmass.com/computer-science/algorithms/relational-algebra-36548

    Solution Preview

    Attached please find the answer.

    In relational algebra, there are six basic operators:

    1. Select (σ)
    2. Project (π)
    3. Union ( )
    4. Cartesian product ( x )
    5. Set difference (-)
    6. Rename (ρ)

    In order to write this query in relation algebra, I will break the query into parts and then combine the result.

    Given the following relations;

    Vendors(vend#, vend_name, vend_phone)
    Parts(part#, part_desc, part_price)
    Supplys(vend#, part#, supply_date)

    Find the part(s) that have been supplied by more than one vendor during February.

    Steps:

    1. Let's find ...

    Solution Summary

    Relational algebra is applied.

    $2.49

    ADVERTISEMENT