# Relational Algebra

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

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.