Ask PHP Expert

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.

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.

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.

PHP , Programming

  • Category:- PHP
  • Reference No.:- M91311784
  • Price:- $100

Guranteed 48 Hours Delivery, In Price:- $100

Have any Question?


Related Questions in PHP

Question continue to build on the skills of providing web

Question: Continue to build on the skills of providing Web page content and structure with HTML and Web page style and layout using CSS. Demonstrate the skill of creating a dynamic Web page that includes JavaScript clien ...

Question develop a 5-6 page word document that describes

Question: Develop a 5-6 page Word document that describes the design for a small Web site that meets the following specifications. 1. The Web site includes four or more Web pages designed according to current usability g ...

Question using the course software and week one template as

Question: Using the course software and Week One Template as a starting point, create a new HTML webpage and include the following: • Write the code to display your name in the largest-size heading element. • Write the m ...

In php write a simple addtion calculator that reads in two

In PHP write a simple addtion calculator that reads in two values and then add them together and display the output. Be sure to validate both inputs and ensure that it can add 0+0 = Sum: 0. The user should be able to inp ...

Final project assignment -requirements specifications -1

FINAL PROJECT ASSIGNMENT - REQUIREMENTS / SPECIFICATIONS - 1. For the final project, you will have to make good use of your CMS using PHP and MySQL for the content delivery. You will have to be able to deliver the conten ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As