1)Consider the following E-R model for the Beta University problem given in Homework1. Examine the E-R model and write the complete relational database schema by following the rules described in class (make sure you underline primary keys and also indicate foreign keys in the schema using arrows as shown in class):

Entities and corresponding attributes:

Potential Donor- donorId, donorName, street, city, state, zip, country, phone, donor Category(multi- valued), 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 Number

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

E-R Model: PotentialDonor MatchingCorp ClassRep Volunteer Event Pledge Payment