QuestionQuestion

In this project 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 must accompany the screen snapshots and source code listings that justifies the technology decisions and which discusses adherence to security best practices, weaknesses, and future enhancements.


Specific Project Requirements:
Develop an application that allows the input, updating, and deletion of customers, homes, salespersons, and sales from your Reston Real Estate (RRE) Oracle database in the VDA that you have been using.
Develop a test 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. Take screen snapshots of each step operation mentioned.
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.

1. All required screen snapshots mentioned above with appropriate labeling and organization

2. Copies of complete listings of all source code files and copies of your web.config or web.xml file, and any other necessary configuration files

3. A well-written document formatted as a single Microsoft Word file describing:
a) The technology and language you used for your application,
b) How you attempted to mitigate security threats, including SQL injection,
c) How to set up your application,
d) How you tested and debugged your application,
e) Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application, and
f) Your impression of how your chosen technology compares to the other two for developing this sort of application

*Outline and describe your strategy to complete this project by showing for each step what you plan to complete and submit (approximately 2 pages total).

*Be sure to include in your description how you will develop a secure application by identifying the technology you will use (PHP, ASP.NET, or Java) and how you will seek to avoid SQL Injection hacks.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

drop table AGENTS cascade constraints ;
drop table CUSTOMERS cascade constraints ;
drop table HOMES cascade constraints ;
drop table SALES cascade constraints ;
drop sequence SEQ_AGENTS;
drop sequence SEQ_CUSTOMERS;
drop sequence SEQ_HOMES;
drop sequence SEQ_SALES;

CREATE SEQUENCE SEQ_AGENTS
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;

CREATE SEQUENCE SEQ_CUSTOMERS
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;

CREATE SEQUENCE SEQ_HOMES
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;

CREATE SEQUENCE SEQ_SALES
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;

CREATE TABLE "AGENTS"
   ( "AGENT_ID" NUMBER ,
"TITLE" VARCHAR2(20 BYTE),
"FIRST_NAME" VARCHAR2(20 BYTE),
"MIDDLE_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(20 BYTE),
"CELL_PHONE" VARCHAR2(20 BYTE),
"HOME_PHONE" VARCHAR2(20 BYTE),
"OFFICE_NUMBER" NUMBER,
"HIRE_DATE" DATE,
CONSTRAINT "AGENTS_PK" PRIMARY KEY ("AGENT_ID")
   ) ;...
$148.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Web Development (HTML, XML, PHP, JavaScript, Adobe, Flash, etc.) Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats