Scribd
Upload
9 views3 pages

Customer Order Management System

The document outlines the database schema for a customer order system, detailing entities such as Customer, Order, Product, Product-Order, Delivery Worker, and Boutique Staff, along with their attributes and relationships. It also includes a customer order form header with fields for customer information, order details, and product selection, along with command buttons for saving, adding, deleting, and printing orders. The schema emphasizes the primary and foreign keys necessary for data integrity and relationships between entities.

Uploaded by

hpregenyuzhong
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views3 pages

Customer Order Management System

The document outlines the database schema for a customer order system, detailing entities such as Customer, Order, Product, Product-Order, Delivery Worker, and Boutique Staff, along with their attributes and relationships. It also includes a customer order form header with fields for customer information, order details, and product selection, along with command buttons for saving, adding, deleting, and printing orders. The schema emphasizes the primary and foreign keys necessary for data integrity and relationships between entities.

Uploaded by

hpregenyuzhong
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

(a)

Entity Customer
Attribute (Primary key) Customer ID
Attribute Customer Name
Attribute Customer Address
Attribute Customer Phone Number

Entity Order
Attribute (Primary key) Order No
Attribute Order Date
Attribute Order Payment Amount /Order
detail/ Quantity ordered
Attribute (Foreign key) Customer ID
Attribute (Foreign key) Staff ID
Attribute (Foreign key) Delivery ID

Entity Product
Attribute (Primary key) Product ID
Attribute Product Type
Attribute Product Name

Entity Product-Order
Attribute (Primary key) Product ID
Attribute (Primary key) Order No
Attribute Quantity

Entity Delivery Worker


Attribute (Primary key) Delivery ID
Attribute Delivery Name
Attribute Delivery Vehicle
Attribute Delivery Phone Number

Entity Boutique Staff


Attribute (Primary key) Staff ID
Attribute Staff Name
Attribute Staff Phone Number
Attribute Staff Email
(b)
(c)
Sorella Ta’rella
Header
Customer Order Form

Customer name: Order No :


Label & text box
Customer phone: Order Date:
Customer address:
Command buttons
Boutique Staff ID:
SAVE
Boutique Staff Name:
Combo box
ADD
Product ID Product Name Product Quantity Amount
DELETE

PRINT

You might also like