Database Assuagement

  

1. Fundraising Database

 

1. Use the Fundraise.pdf file ER       diagram
2. SELECT and non-Select (5 pts. each)

i. Show highest donation amount by member

ii. Show members of company “HealthLast” who is from “Santa Cruz”

iii. Show all members and the city they were from

iv. Check if there are any Members from the city of “Avatar”

v. Show Total count of members per Team sort by TeamName

vi. Delete Donor record(s) from Zipcode “78255”

vii. Add a new donor:

· DonorID: 901

· donationDate: 11-09-2017

· donorName: “Mac Windows”

· donationAmount: 50

· Zipcode: 78200

· MemberID: u101

viii. Update the company name of “AB Funders” to “Health Momentum”

ix. Show all members from the city of “Cardinal” and whose team is under the company “Deceptibots”

x. Show average donation per Member