System rejestracji zamówień

Przedstawiony przykład pokazuje zastosowanie analizy strukturalnej przy modelowaniu systemu.

Przykład dostarczony został wraz z wersją demonstracyjną programu


Pod diagramami zamieszczone są angielskie tłumaczenia terminów.


Schemat systemu

Diagram kontekstowy

    diagram wstępny

        Take order (P1)

        Ship order (P2)

        Manage stock (P3)

        Receive returns (P4)

        Create sales Report (P5)

        Model danych

            Struktura rekordów



Diagram kontekstowy

customer - klient

supplier - dostawca

order - zamówienie

return - zwrot

shipment - dostawa

invoice - faktura

payment - płatność

refund - zwrot pieniędzy

credit check request - sprawdzenie zdolności kredytowej (limitu)


Diagram wstępny

take order - przyjmij zamowienie

ship order - zrealizuj zamowienie (dostarcz towar)

manage stock - zarządzaj zapasami

receive returns - przyjmuj zwroty

create sales reports - sporządź raport sprzedaży


Proces P1

check stock - sprawdź stan zapasów

confirm credit - potwierdź zdolność płatniczą (kredyt)


Proces P2

package order - spakuj zamówienie

unavailable items - niedostępne towary (elementy)


Proces P3

assess stock on hand - oszacuj podręczny zapas

order stock - zamów zapas

pay suppliers - zapłać dostawcom

repackage undamaged returns - wypakuj niezniszczone zwroty

receive stock - przyjmij zapas (dostawę)

supplier invoice - faktura dostawcy

payment - płatność


Proces P4

catalog return - skataloguj zwrot

refund items - elementy do refundacji (zwrotu zapłaty)

reorder returnde items - uwzględnij zwrócone elementy (w bazie zamówień)

refund for return - zwróć zapłate

bill adress - adres rachunku


Proces P5

@OUTPUT DATA FLOW : Sales Report

@INPUT DATA FLOW :

@INPUT DATA FLOW : Employee Name and Supervisor

@INPUT DATA FLOW : Sales Policies and Quotas


Diagram ERD modelujący dane




Struktura rekordów

RECORD_ID ELEMENT_ID
Return Order Number
Return Customer Number
Order Order Number
Order Customer Number
Order Employee Number
Order Date
Order Line Item Order Number
Order Line Item Stock Number
Order Line Item Quantity
Sales Representative Employee Number
Sales Representative Name
Sales Representative Home Address
Sales Representative Home Phone Number
Sales Representative Date Hired
Sales Representative Social Security Number
Sales Representative Date of Birth
Ship Line Item Order Number
Ship Line Item Ship Line Number
Ship Line Item Quantity Shipped
Ship Line Item Ship Date
Ship Line Item Shipment Number
Shipment Order Number
Shipment Shipment Number
Shipment Method of Shipment
Customer Number
Customer Name
Customer Ship Address
Customer Bill Address
Customer Phone Number
Customer Fax Number
Customer Contact Name
Credit Customer Customer Number
Credit Customer Credit Limit
Return Line Item Order Number
Return Line Item Shipment Number
Return Shipment Number
Return Line Item Reason for Return
Returned Product Order Number
Returned Product Shipment Number
Returned Product Cust Number
Returned Product Return Date
Returned Product Reason For Return
Returned Product Request Reorder
Returned Product Return Line Number
Returned Product Ship Line Number
Returned Product Order Line Number
Returned Product Quantity Returned
Return Return Date
Sales Representative Employee Name
Sales Representative Employee Supervisor
Order Line Item Order Line Number
Shipment Ship Date
Stock Stock Number
Stock Stock Description
Stock Quantity on Hand
Stock Quantity on Hold to Ship
Product-Supplier Stock Number
Product-Supplier Supplier Number
Supplier Supplier Number
Supplier Supplier Name
Supplier Supplier Address
Supplier Supplier Phone
Supplier Supplier Fax Phone
Supplier Supplier Contact
Stock Quantity on Pending Orders
Ship Line Item Return Line Number
Stock Price
Product-Supplier Supplier Price
Return Return Number
Return Line Item Customer Number
Return Line Item Return Number
Return Line Item Ship Line Number
Return Line Item Quantity Returned
Return Line Item Request Reorder
Customer Payment Method
Returned Product Return Number
Customer Order Customer Method of Payment
Customer Ship Address Customer Number
Customer Ship Address Customer Name
Customer Ship Address Ship Address
Customer Ship Address Contact Name
Employee Name and Supervisor Employee Name
Employee Name and Supervisor Employee Supervisor
Customer Payment Customer Name
Customer Payment Customer Number
Customer Payment Customer Payment Amount
Customer Payment Customer Order Number
Customer Order Customer Info
Customer Info Customer Name
Customer Info Ship Address
Customer Info Bill Address
Customer Info Phone Number
Customer Info Fax Number
Customer Info Contact Name
Order Items Stock Number
Order Items Quantity
Order Items Stock Description
Order Info Customer Number
Order Info Employee Number
Order Info Order Number
Order Info Date
Order Item Status Order Number
Order Item Status Stock Number
Order Item Status Quantity
Order Item Status Quantity on Hand
Order Item Status Status
Order Line Item Update Order Number
Order Line Item Update Order Line Number
Order Line Item Update Stock Number
Order Line Item Update Quantity
Order Item Status Order Line Number
Stock on Hand Stock Number
Stock on Hand Quantity on Hand
Order Details Order Info
Order Details Order Line Item
Customer Order Customer Order Items
Returned Undamaged Stock Stock Number
Returned Undamaged Stock Quantity on Hand
Received Stock Stock Number
Received Stock Quantity on Hand
Current Stock Stock Number
Current Stock Stock Description
Current Stock Quantity on Hand
Current Stock Quantity on Hold to Ship
Current Stock Price
Stock Product Supplier Order Number
Stock Product Quantity
Received Stock Order Stock Product Order Number
Received Stock Order Internal Stock Number
Received Stock Order Quantity Ordered
Received Stock Order Quantity Received
Stock Product Order Stock Product Order Number
Stock Product Order Supplier
Stock Product Order Order Date
Stock Product Order Internal Stock Number
Stock Product Order Quantity Ordered
Stock Product Order Quantity Received
Stock Product Order Supplier Price
Low Stock Item Stock Number
Low Stock Item Quantity Needed
Supplier Invoice Supplier Name
Supplier Invoice Supplier Order Number
Supplier Invoice Amount Owed
Customer Return Customer Number
Customer Return Customer Shipment Number
Customer Return Customer Stock Number
Customer Return Customer Reason for Return
Customer Return Customer Quantity Returned
Customer Return Customer Request Reorder/Refund
Reorder Items Customer Number
Reorder Items Date
Reorder Items Stock Number
Reorder Items Quantity
Reorder Details Customer Number
Reorder Details Order Number
Reorder Details Employee Number
Reorder Details Date
Reorder Details Order Line Number
Reorder Details Stock Number
Reorder Details Quantity
Refund Items Customer Number
Refund Items Order Number
Refund Items Stock Number
Refund Items Quantity Returned for Refund
Customer Address Customer Number
Customer Address Customer Name
Customer Address Bill Address
Customer Address Contact Name
Back Order Details Order Number
Back Order Details Customer Number
Back Order Details Employee Number
Back Order Details Date
Back Order Details Order Line Number
Back Order Details Stock Number
Back Order Details Quantity
New Stock Received Stock
New Stock Returned Undamaged Stock
Order Confirmation Customer Name
Customer Shipment Customer Name
Customer Shipment Customer Ship Address
Customer Refund Customer Number
Customer Refund Customer Name
Customer Invoice Customer Name
Customer Invoice Customer Bill Address
Customer Invoice Customer Order Number
Customer Invoice Customer Invoice Amount
Sales Policies and Quotas Sales Policies
Sales Policies and Quotas Sales Quotas
Sales Report Monthly Sales
Sales Report Supervisor
Credit Details Customer Name
Credit Details Debts
Credit Check Request Customer Name
Credit Check Request Credit Limit Desired
Unavailable Items Order Line Item
Shipment Record Shipment Number
Shipment Record Ship Date
Shipment Record Packager
Ship Line Item Order Line Number
Return Line Item Order Line Number
Order Confirmation Customer Order Items
Order Confirmation Customer Ship Address
Customer Shipment Customer Order Items
Customer Refund Customer Refund Date
Customer Refund Customer Refund Amount
Customer Invoice Customer Number
Supplier Payment Payment Amount
Supplier Payment Supplier Payment Date
Supplier Payment Supplier Address
Supplier Payment Supplier Name
Supplier Payment Supplier Number
Unavailable Items Quantity
Unavailable Items Order Line Number
Unavailable Items Order Number
Supplier Order Quoted Price
Supplier Order Received Quantity
Supplier Order Order Quantity
Supplier Order Supplier Item Number
Supplier Order Date Ordered
Supplier Order Supplier Address
Supplier Order Supplier Number
Supplier Order Supplier Name
Supplier Order Supplier Order Number
Supplier Payment Supplier Order Number
Supplier Invoice Supplier Address