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 Product_ID, txtProduct_Name, txtQuantity, txtPrice will be deleted. 5 Display txtGrandTotal based on Sum of Subtotals from 'Order Detail' Table. 6 Create Order Details with Item 1: Product_ID = 2, Quantity = 4, Price = 11,000 Item 2: Product_ID = 4, Quantity = 2, Price = 21,000   If you press the 'Simpan' button, the data will be saved to the Order and Order_Detail Tables and stock updates to the product table, with the following mechanism:   Order: Order_ID = txtOrder_ID, Order_Date = txtOrder_Date, Customer_ID = txtCustomer_ID, Customer_RefNo = txtCustomer_RefNo   Order_Detail: Order_ID = txtOrder_ID, Product_ID = ID From the Order Details Table, Quantity = Quantity from the Order Details Table, Price = Price from the Order Details Table   Product: Update Stock added Quantity according to the same Item Code. If there are 2 items in the Order Detail Table, you must update the stock to the 2 items. By calculating Stock = Stock - Quantity. For proof, attach the output stock to the product table before and after the transaction. 7 If the 'Keluar' button is clicked it will exit the application

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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 Product_ID, txtProduct_Name, txtQuantity, txtPrice will be deleted.

5

Display txtGrandTotal based on Sum of Subtotals from 'Order Detail' Table.

6

Create Order Details with

Item 1: Product_ID = 2, Quantity = 4, Price = 11,000

Item 2: Product_ID = 4, Quantity = 2, Price = 21,000

 

If you press the 'Simpan' button, the data will be saved to the Order and Order_Detail Tables and stock updates to the product table, with the following mechanism:

 

Order:

Order_ID = txtOrder_ID, Order_Date = txtOrder_Date, Customer_ID = txtCustomer_ID, Customer_RefNo = txtCustomer_RefNo

 

Order_Detail:

Order_ID = txtOrder_ID, Product_ID = ID From the Order Details Table, Quantity = Quantity from the Order Details Table, Price = Price from the Order Details Table

 

Product:

Update Stock added Quantity according to the same Item Code.

If there are 2 items in the Order Detail Table, you must update the stock to the 2 items.

By calculating Stock = Stock - Quantity.

For proof, attach the output stock to the product table before and after the transaction.

7

If the 'Keluar' button is clicked it will exit the application

Please answer the questions in the order of the questions.

Submit Answers in the form of Java Coding.

Sales
txtGrandTotal
Purchase ID
: txtOrder_ID
Tanggal
: txtOrder_Date
Kode Vendor : txtCustomer_ID
View
txtViewCustomer_Name
Vendor RefNo : txtCustomer_RefNo
Product_ID
Price
txtPrice
Nama Product
Quantity
txtQuantity
txtProduct_Name
Tambah tem
Hapus item
ORDER DETAIL
ID
Nama Product
Quantity
Price
SubTotal
Simpan
Keluar
Transcribed Image Text:Sales txtGrandTotal Purchase ID : txtOrder_ID Tanggal : txtOrder_Date Kode Vendor : txtCustomer_ID View txtViewCustomer_Name Vendor RefNo : txtCustomer_RefNo Product_ID Price txtPrice Nama Product Quantity txtQuantity txtProduct_Name Tambah tem Hapus item ORDER DETAIL ID Nama Product Quantity Price SubTotal Simpan Keluar
SALES ORDER
Order
Customer
- Order ID
- Order Date
- Customer_ID
· Customer_RefNo Char(25)
+ Create/Add
+ Read
+ Update/Edit
Delete
Int (PK)
Order Detail
Customer_ID Int (PK)
Customer_Name Char(150)
Customer Add Char(100)
Date
Order ID
Int (PK)
Int (FK)
F1.*-1.1-- Product ID Int (FK)
Quantity
- Price
Int
-1.1-1,.
Int
+ Create/Add
+ Read
• Update/Edit
Delete
+ Calculate SubTotal
+ Calculate GrandTotal
1.1
Product
- Product_ID
Product_Name Char(50)
- Stock
Int
Int
+ Create/Add
+ Read
+ Update/Edit
- Delete
Transcribed Image Text:SALES ORDER Order Customer - Order ID - Order Date - Customer_ID · Customer_RefNo Char(25) + Create/Add + Read + Update/Edit Delete Int (PK) Order Detail Customer_ID Int (PK) Customer_Name Char(150) Customer Add Char(100) Date Order ID Int (PK) Int (FK) F1.*-1.1-- Product ID Int (FK) Quantity - Price Int -1.1-1,. Int + Create/Add + Read • Update/Edit Delete + Calculate SubTotal + Calculate GrandTotal 1.1 Product - Product_ID Product_Name Char(50) - Stock Int Int + Create/Add + Read + Update/Edit - Delete
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education