Write the transaction log using Table 10.1 from the textbook as your guide. Assume that product ‘ABCD’ has a PROD_QOH = 1,214 at the start of the transaction and that the transaction is representing the addition of 1 new product. Also assume that PART components “AAAA”, “BBBB”, “CCCC” and “DDDD” have a PROD_QOH equal to 547, 108, 249, and 89 respectively. ACTION ITEMSSuppose you are a manufacturer of product ABCD, which is composed of parts AAAA, BBBB,CCCC and DDDD. Each time a new product is created, it must be added to the productinventory, using the PROD_QOH in a table named PRODUCT. And each time the productABCD is created, the parts inventory, using PART_QOH in a table named PART, must bereduced by one each for parts AAAA, BBBB, CCCC and DDDD. The sample database contentsare shown below for these items:Tablename: PRODUCTTablename: PARTPROD_QOH1,214PROD_CODEPART_CODEPART_QOHАВCDAAAA547BBBB108CCCC249DDDD89 TABLE 10.1A TRANSACTION LOGTRL_ TRX_PREVNEXTOPERATION TABLEROW IDATTRIBUTE BEFORE AFTERIDNUMPTRPTRVALUEVALUE341101Null352START****StartTransaction352101341363UPDATEPRODUCT1558-QW1 PROD_QOH2523363101352365UPDATECUSTOMER10011CUST_525.75615.73BALANCE365101363NullCOMMIT**** End ofTransactionTRL_ID = Transaction log record IDTRX_NUM =Transaction numberPTR = Pointer to a transaction log record ID(Note: The transaction number is automatically assigned by the DBMS.)%3D

The ask is to create the transaction log for creation of a new product.

Write the transaction log using Table 10.1 from the textbook as your guide. Assume that product ‘ABCD’ has a PROD_QOH = 1,214 at the start of the transaction and that the transaction is representing the addition of 1 new product. Also assume that PART components “AAAA”, “BBBB”, “CCCC” and “DDDD” have a PROD_QOH equal to 547, 108, 249, and 89 respectively.

Write the transaction log using Table 10.1 from the textbook as your guide. Assume that product ‘ABCD’ has a PROD_QOH = 1,214 at the start of the transaction and that the transaction is representing the addition of 1 new product. Also assume that PART components “AAAA”, “BBBB”, “CCCC” and “DDDD” have a PROD_QOH equal to 547, 108, 249, and 89 respectively.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter8: Arrays

Section: Chapter Questions

Problem 3E

See similar textbooks

Similar questions

Visual Studio produces Personnel.mdf. A database table called "Employee" need to include the employee ID, name, position, and hourly pay rate of each worker. The employee ID serves as the primary key. It would be helpful to have five example rows in the Employee table. The Employee table may be seen in a DataGridView inside an application.
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.
Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe
To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe.
Add courses to the cart: Customer will only be able to add a course if the title is in the master’s list.Once added, the course name and its price need to be added to a shopping cart list, the information -title and price - needs to be separated (as in master list) by any delimiter of your choice (like: colon,space, dash etc). Customer should be able to view the shopping cart list after adding a course. Delete a course from cart: Customer will enter the name of the course and the program will lookfor the course in the shopping cart list to be deleted from. View the shopping cart list after deletion. Check out course: Customer should be able to view the list of the courses and their individualprice that are being selected by the user, then view the total price of all the courses in theshopping cart. Again, you need to use a for loop to iterate over the shopping list, separate the titleand price and view the information as shown in sample I/O. Directly printing the list will…
In Senior Project Website, the user requests the website to search for previous senior projects, the website displays the search web form, the user inputs the keywords to be used for the search process, the user submits the search criteria to the website, and the website requests a remote database to search for senior projects that fulfill the requested criteria (keywords). The remote database returns back a Boolean value (indicating if the search is successful or not) and a list of found senior projects (the list is empty if not successful), If the search is successful, the website displays the list of received senior projects, else, the website displays error dialog box indicating that no projects were found. Q2. For Senior Project Website System described above, students are required to conduct the following task: a) Design the Sequence Diagram of Senior Project Website System described above.
Using the getFirst() function as a template for reference, code the saveProduct() function that will be called when the save button of the depicted screen is clicked. The text from the JTextFields will be used as parameters.The database schema for the SQL tables are also depicted. The number of the product is the primary key and is set to auto-increment. public Product getFirst() { if (openConnection()) { try{ Product temp = null; String query = "SELECT * FROM products order by number asc limit 1"; // our SQL SELECT query. Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); // create the java statement ResultSet rs = st.executeQuery(query);// execute the query, and get a java resultset while (rs.next()) // iterate through the java resultset { temp = new…
8. In the following code below, the code selects an Employee object by primary key. However you are missing the line of code to create the employee variable. What line of code are you missing? [HttpGet] public IActionResult Edit(int id) { ViewBag.Action = "Edit"; ViewBag.Departments = context.Departments.OrderBy(d => d.DepartmentName).ToList(); ________________________________________________ return View(employee); } 1. var employee = id 2. var employee ="select * from Employee where Id = id"; 3. var employee = context.Employees.Find(id); 4. context.Employees.Find(id) = employee;
Use Visual Studio to create a database named Personnel.mdf. The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table. Create an application that displays the Employee table in a DataGridView control.
You are required to develop an appropriate data structure which keeps the record of Sent items ofEmail.
Make the functions below according to the attached class diagram and GUI program mockup. No The function to be made 1 Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021 When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. 2 Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID 3 If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. 4 When the ‘Hapus’ button is clicked, data from…
There's a "users" table that has more than 1M rows of "users" information. The image below are the first 3 rows.Implement a SQL query that retrieves the "email" and "friend_count" of the "user_id" with the most friends.