Entities and corresponding attributes:

Potential Donor- donorId, donorName, street, city, state, zip, country, phone, donor Category(multivalued), donorCircle, graduationYear(multi-valued), amountDonatedLastYear, amountPledgedThisYear, amountPaidThisYear, donorMatchCorp, spouseName, spouseMatchCorp

Matching Corp- matchCorpName, street, city, state, zip, country

Event eventName, eventDate, eventTime, eventLocation, eventOrganizer, eventTotalPledged eventTotalPaid

ClassRep graduationYear, classRepName, street, city, state, zip, country, classRepPhoneNumber

Volunteer volunteerName, street, city, state, zip, country, volunteerPhoneNumber

Pledge pledgeNumber, pledgeAmount, pledgeDate, numPaymentsChosen, pledgeAmountPaid, numPaymentsMade

Payment - datePaid, amount Paid, paymentMethod, creditCardType, credit Card

2. Using your Beta University relational database schema, write relational algebra statements (combination of SELECT, PROJECT, JOIN, and SET operations) to perform the following database operations:

a. Find the names and phone numbers of donors who donated more this year compared to last year

b. Find the names and phone numbers of donors who belong to the category Alumnus

c. Find the id numbers of donors who donated more than $500 during the event Bake Sale on 12/15/2013

d. Find the names and graduation year of donors who sent their pledge amount in the year 2013 using Visa credit cards

e. Delete all pledge records from donor bearing donorId 12463

Note: Please use the relational database schema to question this question please

Thanks

Subject: Design of Database