1 / 18

LS 560 Database Assignment

LS 560 Database Assignment. Group 6 Heather Castle Avis Carter Erin Collins Rebecca Domm. 4/4/2013. http://www.cspwal.com/index.aspx.

Download Presentation

LS 560 Database Assignment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. LS 560 Database Assignment Group 6 Heather Castle Avis Carter Erin Collins Rebecca Domm 4/4/2013

  2. http://www.cspwal.com/index.aspx

  3. 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.

  4. After clicking on Supportive services from the home page, user will see this at top of page.

  5. 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.

  6. 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.

  7. Mock-up Design Step 1 To see if you qualify for energy assistance, submit your information below.

  8. 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:

  9. Mock-up Design You Qualify! To Schedule an Appointment Online Click Here

  10. Table Tabs & Fields

  11. Table Tabs & Fields

  12. 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.

  13. SQL Design View

  14. SQL Statement #1

  15. 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.

  16. Meet the Standard Report

  17. SQL Statement #2

  18. 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.

More Related