Question

A nonprofit organization depend on a number of different types of persons. The system needs to...

A nonprofit organization depend on a number of different types of persons. The system needs to maintain the following data for all persons: SSN, Name, Address, City, City, State, Zip, and email. There are three types of persons: employees, volunteers, and donors. Employees have a unique Date Hired attribute, and volunteers have a distinct Skill attribute. Donors donate items. Item has attributes like Item ID and Description. A donor may donate multiple items. An item may be associated with no donor or one donor.

Occasionally, there are persons other than the three types (employees, volunteers, and donors). In other words, a person may not belong to any of these three types. Also, a person may belong to two or more of these types (e.g., a person is an employee and also a donor). Create the ERD for the system in Microsoft Visio.

Homework Answers

Answer #1

ERD

  • Employee, Volunteer and Donor are subclasses of Person.
  • The primary key of Person is SSN and it is given as the foreign key in each subclasses.
  • This is a incomplete overlapping relationship because there are persons other than the three types and a person may belong to two or more of these types .
  • A donor may donate multiple items. An item may be associated with no donor or one donor. S this relationship is optional one to mandatory many.
  • All the entities, attributes, keys, relationship and cardinalities are shown using crow's foot notation in the ERD.
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A nonprofit organization depend on a number of different types of persons. The system needs to...
A nonprofit organization depend on a number of different types of persons. The system needs to maintain the following data for all persons: SSN, Name, Address, City, City, State, Zip, and email. There are three types of persons: employees, volunteers, and donors. Employees have a unique Date Hired attribute, and volunteers have a distinct Skill attribute. Donors donate items. Item has attributes like Item ID and Description. A donor may donate multiple items. An item may be associated with no...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...