Homework 2
1. Transform the following ER diagram to its corresponding relational schema:
![]()
2. Using the resulting relational schema from exercise 1, use relational algebra
to express the following queries:
a) List the ssn and name for all donors whose phone number
starts with 352 and who have at least one donation worth $25 or more.
b) List the employee id, name, and salary for all employees
that have brought in a donation worth more than their salary.
c) List all the donors who have donated both volunteer time
and articles.
d) List of the employees who have made at least one donation
worth 1% or their salary.
