Scribd
Upload
24 views1 page

2.ERD Diagram

The document shows an entity relationship diagram that displays the relationships between customers, products, orders, invoices, deliveries and staff. It shows how customer data is related to orders and invoices which are also related to product and staff information. Delivery details are also linked to orders.

Uploaded by

Niteshwar Mani
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
24 views1 page

2.ERD Diagram

The document shows an entity relationship diagram that displays the relationships between customers, products, orders, invoices, deliveries and staff. It shows how customer data is related to orders and invoices which are also related to product and staff information. Delivery details are also linked to orders.

Uploaded by

Niteshwar Mani
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
You are on page 1/ 1

Entity Relationship Diagram

DELIVERY_ORDER

DELIVERY_REF
CUSTOMER DELIVERY_DATE
DELIVERY_ORDER_NO
DELIVERY_INVOICE_NO
DELIVERY_RECEIVED_DATE
CUSTOMER_ID DELIVERY_STATUS
CUSTOMER_NAME ITEM_ORDER DELIVERY_STAFF_ID
CUSTOMER_CONTACT
CUSTOMER_EMAIL
CUSTOMER_ADDRESS
ORDER_NO
ORDER_DATE
PRODUCT ORDER_PRODUCT_CODE
ORDER_CUSTOMER_ID STAFF
ORDER_UNIT_PRICE
ORDER_QUANTITY
PRODUCT_CODE ORDER_TOTAL_PRICE
PRODUCT_DESC ORDER_STAFF_ID STAFF_ID
PRODUCT_UNIT_PRICE STAFF_NAME
PRODUCT_STOCK STAFF_DEPARTMENT
STAFF_EMAIL
INVOICE

INVOICE_NO
INVOICE_ORDER_NO
INVOICE_DATE
INVOICE_AMOUNT
INVOICE_PAID_DATE
INVOICE_PAID_MODE
INVOICE_PAID_REF

You might also like