Computer Science homework help

Project for Internet Programming
– Bill Pay System
I. Introduction
This project let you apply the programming skills you learned in Internet Programming
class by developing an application called Online Bill Payment. You will build a website
which serves as an online service website, where one can register as a customer. Once
registered, a customer can log in and log out the website. Customers can update its
profile/personal information, add/update payee information, pay one or more payees,
and review payment history.
II. Requirements
1. You need to design a simple database with SQL LocalDb. Three tables are required
in the DB:
 Customer –information of the registered customer
 Payee — each customer can have a saved list of payees with all information
necessary to send the payment
 PaymentHistory – stores the payment history of all customers
You can also add additional tables that you think are needed.
2. The website is free. Anyone can register as a customer. Upon registration, the
customer information is collected and saved in the database; an id is assigned the
customer.
3. Registered customers can log in and log out the website. The only pages an
unregistered person can access is the home page and registration page.
4. A customer can update his/her personal information on the website.
5. On payee management page, a customer can add new payee or update existing
payee. One customer can have multiple payees.
6. On payment page, a customer can pick one or multiple payees to pay. When
payment is submitted, you only need to save the payment information in the
database. A customer can review payment history which can be filtered by a date
range.
7. After each class, think about how to apply the skills learned from that class to the
project.
8. Bonus – This is optional. Add an administration page, where someone with admin
role can view customer list, deactivate/activate customers. Once deactivated, the
customer can no longer login or use the website.
9. You can research on the internet. But do not copy code directly from webpages.
10. You will not only be graded by the correctness, but also by the quality of code. I
expect your code to be clear and follow good programming practice.
11. You can work alone or in a team of 4 students maximum.
III. Deliverables
1. Project Reports – You need to write a project report, where you need to:
 Provide introduction of the project
 Show screenshots of the pages you built
 Explain how each page work, and how are the pages connected
 What skills you learned from class are used in your project
 If this is a teamwork, only one report is needed for the team. The report
needs to clarify each team member’s contribution to the project.
2. Presentation – At the end of the semester, you will prepare a demo video either by
shooting a video with your phone or using screen recording software such as
“screencastify” Chrome plug in.
3. Code – At the end of the semester, Zip all the code into one file and submit to
blackboard. In the same folder, add an instruction file to provide special instructions
on how to run the program as well as short descriptions of the folders/files in the
project.
IV. Key Dates
End of day May 7th — Project Code, Demo Video and Report.