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.ResourcesPlace Order Functionality: To-Do List [DOCX].Capestra Furniture SRS [DOCX].Implementing place order functionality, part 1. | TranscriptImplementing place order functionality, part 2. | TranscriptImplementing place order functionality, part 3. | TranscriptImplementing place order functionality, part 4. | TranscriptAssignment InstructionsComplete 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

nstructionsIn the Final Penetration Test Proposal Template, add previous submissions, make updates and corrections based on the feedback received from your instructor, and add the Maintaining Access and Covering Your Tracks plans.So, your final proposal will include the following components:Rules of Engagement (from Deliverable 1)Reconnaissance Plan (from Deliverable 2)Scanning Plan (from Deliverable 2)Gaining Access Plan (from Deliverable 3)Maintaining Access Plan (New)Covering Your Tracks Plan (New)Use the Final Penetration Test Proposal template to complete your work.

Chapter 5 - DQ #1-4 1.What is an artificial neural network and for what types of problems can it be used?2. Compare artificial and biological neural networks. What aspects of biological networks are not mimicked by artificial ones? What aspects are similar?3. What are the most common ANN architectures? For what types of problems can they be used?4. ANN can be used for both supervised and unsupervised learning. Explain how they learn in a supervised mode and in an unsupervised mode.exercise 6 Go to Google Scholar (https://scholar.google.com/). Conduct a search to find two papers written in the last five years that compare and contrast multiple machine-learning methods for a given problem domain. Observe commonalities and differences among their findings and prepare a report to summarize your understanding. internet exercise #7 Go to neuroshell.com. (https://try.neuroshell.com/index/) Look at Gee Whiz examples. Comment on the feasibility of achieving the results claimed by the developers of this neural network model.Chapter 6 - DQ #1-5 1.What is deep learning? What can deep learning do that traditional machine-learning methods cannot?2. List and briefly explain different learning paradigms/ methods in AI.3. What is representation learning, and how does it relate to machine learning and deep learning?4. List and briefly describe the most commonly used ANN activation functions.5. What is MLP, and how does it work? Explain the function of summation and activation weights in MLP-type ANN.exercise 4:Cognitive computing has become a popular term to define and characterize the extent of the ability of machines/computers to show “intelligent” behavior. Thanks to IBM Watson and its success on Jeopardy!, cognitive computing and cognitive analytics are now part of many realworld intelligent systems. In this exercise, identify at least three application cases where cognitive computing was used to solve complex real-world problems. Summarize your findings in a professionally organized report.attached text book for reference. The above assignments should be submitted in one-word document. Include an APA cover page and a reference page.