ntroduction to database systems Question: Create an ER diagram relational schema and queries of a charity donation application that has classes as follows: Donor(name, address, mobile number, email) with subclasses: DonateMoney(name, amount, card number,security code) and DonateOther(item, name, address, mobile number, email), Volunteer(name, address, mobile number, email) and Organization(name, address, mobile number, email). The description of the application is as follows: the user can either donate money or donate other such as food, clothes,books, etc where he/she will have to first select the organization he/she is willing to donate to and then fill in the required information. The user could also volunteer by selecting what organization he/she wants to volunteer to and filling in the required information.
Introduction to
Question: Create an ER diagram relational schema and queries of a charity donation application that has classes as follows: Donor(name, address, mobile number, email) with subclasses: DonateMoney(name, amount, card number,security code) and DonateOther(item, name, address, mobile number, email), Volunteer(name, address, mobile number, email) and Organization(name, address, mobile number, email).
The description of the application is as follows: the user can either donate money or donate other such as food, clothes,books, etc where he/she will have to first select the organization he/she is willing to donate to and then fill in the required information. The user could also volunteer by selecting what organization he/she wants to volunteer to and filling in the required information.
Step by step
Solved in 2 steps with 1 images