180 likes | 269 Views
LS 560 Database Assignment. Group 6 Heather Castle Avis Carter Erin Collins Rebecca Domm. 4/4/2013. http://www.cspwal.com/index.aspx.
E N D
LS 560 Database Assignment Group 6 Heather Castle Avis Carter Erin Collins Rebecca Domm 4/4/2013
The Community Service Programs of West Alabama, Inc. (CSP) is a private, nonprofit agency that works with low-income and vulnerable population in West Alabama. • One service offered is assistance to a person with or without family members who need help paying their electric bill. • This service is found under Supportive Service – (Assistance and Vouchers), a maximum amount income chart is displayed. From the chart, user determines if they are eligible for assistance.
After clicking on Supportive services from the home page, user will see this at top of page.
Left: From home page, click on supportive services, then on assistance & vouchers. On that page, user will see above. From that chart, determine if eligible for help or not.
The proposed changes may eliminate the client having to search for information on several different pages by taking the proximity(P) out of C.R.A.P, and putting all items alike in a central location. • We will include an input form for the client to input the number of people in household and maximum monthly gross income. The database will hold the information and determine if they are eligible for energy assistance or not. • Display will indicate if they qualify or not. Either way they will have the option to click a link to another form for making an appointment to speak with a representative.
Mock-up Design Step 1 To see if you qualify for energy assistance, submit your information below.
Mock-up Design Step 2 Enter the number of people in your household and your monthly gross income in the boxes below to find out if you are eligible for energy assistance under LIHEAP Program. Number of people in your household: Your gross income for one month:
Mock-up Design You Qualify! To Schedule an Appointment Online Click Here
Relationships Link Tables to Generate a Report Note: If maximum gross income is greater than or equal to their monthly gross income for the same number of people in household as stated in the guideline, the report will indicate if they qualify or not.
Description of SQL #1 • This SQL statement will create a report and list those who have qualified for energy assistance based on the information they provided in the online form. The selected fields will be pulled in the report and will include information for each customer such HouseholdFamilysizeID, Guideline, MonthlyGrossIncome. The fields pulled are selected from the two tables:2013GuidlietoQualify and Qualifer in the database.
Description of SQL #2 • This SQL statement creates a report to list those who did not qualify. The information pulled is the household family size ID number with their monthly gross income and the guideline of the maximum gross income. The fields pulled are selected from the two tables:2013GuidlietoQualify and Qualiferin the database.