SALES ORDER Order Customer · Order ID • Order Date Customer ID · Customer_RefNo Char(25) Int (PK) Date Customer ID Int (PK) Customer Name Char(150) Customer Add Char(100) Int (FK) 1. 1.1.1. + Create/Add + Read Create/Add + Update/Edit Delete Read -Update/Edit

LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
5th Edition
ISBN:9781337569798
Author:ECKERT
Publisher:ECKERT
Chapter10: Common Administrative Tasks
Section: Chapter Questions
Problem 13RQ
icon
Related questions
Question

Create a Sales Order Form with the following attached mockup:

Submit Answers in the form of Java  and Capture Output GUI.

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
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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Web Page
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning