ERD Sample Problem Entity Relationship Diagram ERD Sample

ERD Sample Problem Entity Relationship Diagram (ERD)

Sample problem statement Provide a user-friendly database solution that will help a community aid organization track aid given by household, as well as donors of designated assistance, and the amount of that designated assistance, not yet allocated.

Business Rules • The community aid organization • will be in the state of KY • will track aid for individuals in only one county. • Reporting year does not necessarily align with calendar year • • • Aid is tracked to a household by month Each household must have one and only one head of household. Head of household, not location, is primary way to identify a household. An individual can belong to one and only one household in any given month Individuals in a households must either be head or have relation to head stored. Aid is divided into types • Minimum time between distribution varies by aid type bur is measured in months • Amount of aid distribution varies based on number of individuals in that household and aid type • Donors may designate amount of assistance by month by type

• System needs to ensure • Household does not over draw any type of aid in a month • Donors designated amount of assistance by type is not exceeded in a month • Unused designated donations roil forward and add to that donor's allocation for the next month • On an ad-hoc basis the Agency needs to report • number of households served by month • Average statistics by household by month • Number of members • Number of generations in household • Average of household by month • System needs to allow several workers accessing data simultaneously • History is important and agency will gain significant value maintaining data over decades

• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables

Call me if you have questions Adjunct Instructor – Charles W (Bill) Marshall Email cmarshall 0050@kctcs. edu 606 375 2076