Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!


Clayton State University Implement Semantics for Place Action Project Program

Clayton State University Implement Semantics for Place Action Project Program

Question Description

Most application forms do not interact solely with a single table directly but instead select, insert, update, and delete data from multiple tables. Because multiple statements may need to be executed, the use of transactions is necessary to ensure atomicity, consistency, isolation, and durability. These four characteristics are also known as the ACID properties:

  • The atomic property helps ensure that a transaction is fully complete or not started at all. If there is an error, the database should revert any changes to the start of the transaction.
  • A transaction also helps to enforce consistency in the system state, meaning that the system should always be in a valid state.
  • A transaction should run in isolation, meaning that it should be the only action that should be running on the system at one time. If two (or more) transactions are performing the same function simultaneously, the transaction isolation will ensure that each transaction thinks it should have exclusive use and lock on the database rows that the transaction affects.
  • The durability of the transaction means that once the transaction has completed successfully, all of the changes should be permanent.

In this assignment, you will create the functionality in your CapestraApp project to create new orders. The customer for whom the order is being placed is selected from a drop-down list of all current customers. The product is selected from a drop-down list displaying all current products. Once the customer and product have been selected, the user should enter the desired quantity to be ordered. Once all of the fields have been inputted, the user can then click the Place Order button, which will call a new method called placeOrder(). This method should check to see that all fields have been filled, and it should display an error if this is not the case. Then, placeOrder() should call a similarly named method in the database interface that attempts to place the order.


Assignment Instructions

Complete these steps for this assignment.

1.In the (database interface) placeOrder() method, a transaction composed of a series of statements will need to be executed. If at any time there is an error, all of the statements should be reverted. In order, the following SQL statements must be executed:

  • Check that there is enough quantity of the product to be ordered. If not, raise an exception; otherwise, continue.
  • Insert a record in the order table to include the customer ID and date of the order. The date should be today’s date obtained from the operating system.
  • Insert a record in the order_detail table to indicate the order ID, product ID, and quantity.
  • Update the product table to deduct the number of items ordered.

2. If the transaction is successful, inform the user that the order has been placed. If there was an exception, inform the user of the issue.

3. While your application is running, take screen shots of both successful and unsuccessful orders, and a screen shot of the MySQL Workbench screen showing their insertion.

  • Do not capture your entire desktop—just capture the individual screens.
  • Paste all screen shots into a single MS Word document.
  • Your name should appear at the top of the MS Word document.
  • Name your document, following this pattern: Austin_Week8.docx.

4. Create a .zip file containing your CapestraApp project.

  • Before zipping your project, right-click the project and “clean” it. This greatly reduces the file size and speeds up the program’s performance.
  • Then close NetBeans.

5. Add the MS Word document with your screenshots to your .zip file.

6. Submit your cleaned CapestraApp project in an appropriately constructed and correctly named .zip file.

  • Rename your .zip file following this pattern: Austin_Week8zip

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.