Reference no: EM13753484
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.
|
Uses predetermined overhead rate based on direct labor-hours
: Sawyer Manufacturing Corporation uses a predetermined overhead rate based on direct labor-hours to apply manufacturing overhead to jobs. Last year, the Corporation worked 48,000 actual direct labor-hours and incurred $552,000 of actual manufacturing ..
|
|
Practice evaluating mobile interactions
: How did your choices affect the outcome. How did this method of evaluation compare to the heuristic evaluation you did - what are the benefits of each one
|
|
Future performance of the firm
: Valuation of a firm's financial assets is said to be based on what is expected in the future, in terms of the future performance of the firm, the industry, and the economy.
|
|
The federal long-term tax-exempt rate
: Through a “Type B” reorganization, Golden Corporation acquired 90% of Retriever Co stock by October 2 of the current tax year ending December 31. At the time the 90% was acquired, Retriever Co was worth $800,000 and the Federal long-term tax-exempt r..
|
|
Develop an application that allows the input and updating
: 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
|
|
Prepare general journal entries
: Merry land's had inventory balance $32 570 at close of accounting period. the following sales & purchases are for current period. Prepare general journal entries (ignoring GST) assuming: 1. a periodic inventory system is used 2. a perpetual inventory..
|
|
Verify your implementation by viewing the data dictionary
: Implement the authorization table using any two suitable application models presented - Use the scripts provided to create a schema - Create three different profiles based on the criteria.
|
|
Company more than just periodic interest payments
: Assume that a company issues a bond at 92 having a face value of $5,000 and a coupon interest rate of 6%. The bond pays interest annually and has a five-year-maturity time frame, and bonds of similar risk are currently paying interest rates of 8%.
|
|
Identify five different it systems
: Identify five different IT systems that have affected business in the past few years (i.e., business software applications, networks, hardware, internet-based technologies, databases)
|