Final Project/Authentic Assessment

In the final project of the course, you will select a programming language and technology (PHP, ASP.NET (VB.NET or C#), or Java), and based on a set of business requirements, design, build, and test a Web database application. The design must include consideration of security best practices, including validating all input and reducing the possibility of SQL injection. A well-organized Word document should accompany the source code that justifies the technology decisions and which discusses adherence to security best practices, weaknesses, and future enhancements.
Provide a workable link so you can show your code to your classmates, and provide feedback on other students' submissions. Your grade will be determined based on the following:

Overall web application and database design (20 percent)

Functionality (40 percent)

Test cases (20 percent)

Word documentation (10 percent)

Security threat reduction (10 percent)

Specific Project Requirements:

  1. Develop an application that allows the input, updating, and deletion of customers, homes, salespersons, and sales from your Reston Real Estate (RRE) Oracle database on Nova that you have been using since Project #2.
  2. Develop a scenario that adds 3 (three) homes, 3 (three) customers, 1 (one) salesperson (i.e. agent), and 3 (three) sales. Each new customer must be involved in a separate sale for one of the new homes. The new salesperson is involved in all three sales. In other words, create a way to enter all this data and then actually do it, taking screen snapshots of each step.
  3. After the initial data above are input, change one customer's last name, another customer's address, the salesperson's phone number, and the sale amount of one of the homes. Take screen snapshots to prove that this worked.
  4. Provide an option to allow the user to display the total number of homes sold in your database (the new ones and any previous ones), the total sales amount (new and existing), and the average sales amount per home (new and existing). Take screen snapshots to prove that this worked.
  5. Finally, delete all 3 (three) of the new customers, homes, sales, and the new salesperson. Take screen snapshots to prove that this worked.
  6. Project should include an interface for Insert/Update/Delete /Display Records. Each project page should have navigation to the main/index project page.

Deliverables:

Submit one.zip file (YouNameFinalProject.zip) that includes the following files:

  1. All code and deployment details to allow a successful demo to be performed by the instructor of yourapplication. You must provide an active hyperlink to your application in the WebTycho Authentic Assessment student notes section that will go directly to your application's main page.
  1. Copies of complete listings of all source code files.
  1. Copies of your web.config or web.xml file, and any other necessary configuration files.
  2. SQL scripts used to populate/create database.

5. A well-written document formatted as a single Microsoft Word file describing:

  1. The technology and language you used for your application.
  2. How you attempted to mitigate security threats, including SQL injection.
  3. How to set up your application.
  4. The test data and results you used for your scenario.
  5. Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.
  6. Your impression of how your chosen technology compares to the other two for developing this sort of application.