Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The ERD shows the following entities: Person: This entity stores the basic information about all persons, including their SSN , name, address, city, state, zip,
The ERD shows the following entities:
Person: This entity stores the basic information about all persons, including their SSN name, address, city, state, zip, and email.
Employee: This entity stores the additional information about employees, such as their date hired.
Volunteer: This entity stores the additional information about volunteers, such as their skills.
Donor: This entity stores the additional information about donors.
Item: This entity stores the information about items, such as their ID and description.
The ERD also shows the following relationships:
PersonEmployee: This relationship indicates that a person can be an employee.
PersonVolunteer: This relationship indicates that a person can be a volunteer.
PersonDonor: This relationship indicates that a person can be a donor.
DonorItem: This relationship indicates that a donor can donate one or more items.
ItemDonor: This relationship indicates that an item can be associated with no donor or one donor.
The ERD is designed to be flexible enough to accommodate the occasional person who does not belong to any of the three types employee volunteer, or donor as well as the person who belongs to two or more of these types.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started