Create a Sales Order Form with the following attached mockup:

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
icon
Concept explainers
Question

Create a Sales Order Form with the following attached mockup:

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 with 1 images

Blurred answer
Knowledge Booster
Query Syntax
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