In the final project of the course, you will select a programming language and technology (PHP, ASP.NET (using 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.
Your grade will be determined based on the Rubric
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 FA14-CMIS440-485 that you have been using since Project #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.
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.
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.
Finally, delete all 3 (three) of the new customers, homes, sales, and the new salesperson. Take screen snapshots to prove that this worked.