Sample Problem Statement Sample problem statement Provide a
Sample Problem Statement
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
• organization Tables
Business Rules • The community aid organization • will be in the state of KY • will track aid for individuals in only one county.
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
• organization • aidmonth Tables
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
• organization • aidmonth • Individuals • Households Tables
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.
• organization • aidmonth • Individuals • Households • Hse_members Tables
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
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.
• organization • aidmonth • Individuals • Households • Hse_members • relationship Tables
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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype Tables
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
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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution Tables
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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• System needs to ensure • Household does not over draw any type of aid in a month
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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 roll forward and add to that donor's allocation for the next month
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
• organization • aidmonth • Individuals • Households • Hse_members • relationship • aidtype • aidtyp_sizcat • Distribution • Donationsource • donationbudget Tables
• 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
- Slides: 39