Goods Receiving b Supplier Check Delivery Delivery Note Place Goods in Delivery Dock P.O. Copy M1 Matched P.O. Purchase Orders
Allocate Stock Location T2 Matched P.O.s Matched P.O. Remove Goods from Delivery Dock M2 Stock New Stock 3
Stock Keeping Store Stock Store Goods in Depot Investigate Current Processing K Current Physical Data Current Physical Data Flow Model ( ) (Elementary Process Description) I/O /
1.1 1.1 .. . .
.. . .. . . . . .. (<12) Investigate Current Data Logical Data Modelling LDM (Entity Relationship
Diagrams, E-R) : (Logical Data Structure) Investigate Current Data A B A B A B
m:n 1:m 1:1 Investigate Current Data Optionality supplier of Supplier
supplier for supplier of Despatch despatch of Delivered by placed with Purchase Order ordered by despatched
in supplied by ordered by Product customer order for order for results in held as holding of result of delivered by Delivery Stock
delivery of Customer orderer of ordered by Customer Order Investigate Current Data -- (master-detail), , , (access paths),
, .. Investigate Current Data PRODUCT Product Number *Product Type Code Product Name Product Description Release Date Sell-by Date (special promotional products) Sell-from Date Standard Purchase Price Standard Selling Price PRODUCT SUBSTITUTE *Product Number [substitute] *Product Number [substituted] PRODUCT TYPE Product Type Code
Product Type Name Product Type Description DEPOT ZONE Depot Zone Number Depot Zone Description PURCHASE ORDER Purchase Order Number *Supplier Number Suppliers Delivery Reference Purchase Order Date Purchase Order Status Delivery Date Delivery Start Time Delivery End Time SUPPLIER Supplier Number Supplier Name Supplier Address
Supplier Tel. No. Supplier Contact Name SUPPLIER INVOICE *Purchase Order Number Suppliers Invoice Number Invoice Date PURCHASE ORDER ITEM *Purchase Order Number *Product Number *Invoice Number Quantity Required Quantity Confirmed Quantity Delivered Quantity Accepted Invoiced Quantity Agreed Unit Price Required-By Date Required-By Time-Period STOCK
Stock Id *Purchase Order Number *Product Number *Zone Code Quantity Stocked Quantity Stocked Quantity Reserved DEPOT ZONE ALLOCATION *Depot Zone Number *Product Type Code Investigate Current Data : . , , , mandatory/optional. (Read, Create, Delete, Modify)
Derive Logical View of Current Services , . . . Assemble Investigation Results ( ) )
Stage 2: Business System Option Stage 2: Business System Option . . . : Define BSOs: Select BSOs: BSOs
104 105 106 107 108 109 110 Name System must support up to 100,000 live products Record proposed purchase order Confirm purchase order Record customer order Arrange despatch of customer orders Cust. Orders to be kept 3 months then archived Provide delivery to despatch audit trail BSO 1
BSO 2 BSO 3 BS0 4 X X X X X X X X X
X X X X X X X X X BSOs 2-3 /
. BSO BSO . . BSO BSO
Stage 3: Definition of Requirements Stage 3: Definition of Requirements Define required system processing Develop required data model Derive system functions Develop user job specifications Enhance required data model Develop specification prototypes Develop processing specification Confirm system objectives Assemble requirements specification Derive system functions
menu Derive system functions :
On-line Off-line Function Function Input Input Process Update or Events
Enquiry Enquiry Process Triggers Control Syntax Errors Errors Function Definition Boundary Output Event & Valid Process Output Enquiry
Output Integrity Function Errors Error Error Process Output Database 1 Maintain Purchase Order 1.1
b Purchaser P.O.Quantities Product Details Supplier Details Create Proposed Purchase Order 1 Proposed P.O. Availability Supplier Amended P.O. Stock Clerk
A Swiss mathematician, Leonhard Euler (1707 to 1783), published the first paper on graph theory in 1736. The paper was based on the Seven Bridges of Konigsberg problem. Residents of Konigsberg wanted to know if it was possible to find...
Challenge: Without the character of "Puck," Shakespeare's play would have lost its value as a comedy. Yes or No? Make your argument. Challenge: Shakespeare makes a good case that it is possible to control another person's actions. Yes or No?...
The impact of consumer-facing technology was a huge topic among Show attendees. One of the Show's most popular workshop tracks, "Tech Trends," presented fascinating updates on the latest tech ideas that are driving rapid change throughout the grocery industry. ......
Life Estate "Life tenant" is owner under terms of a will until their death, then title goes to remainderman named in will, Life tenant has complete right to sell timber, but "remainderman" may be able to sue for a "wasting"...
Chapter 18 Carboxylic Acids and Their Derivatives. ... the Dehydration of Amides A nitrile can be formed by reaction of an amide with phosphorous pentoxide or boiling acetic anhydride Hydrolysis of Nitriles A nitrile is the synthetic equivalent of a...
THE LATER MIDDLE AGES: 1300-1450 Learning Objective: Students will understand the evolution of European society from antiquity through the Later Middle Ages and analyze the ways in which religious, economic, and social upheaval affected late-Medieval society. Major Periods in European...
The rock art "adds to our knowledge of the animal's appearance that, without the discovery of a mummified animal, would have remained conjecture," says the study. "The artist has depicted a tail with tufted tip, the ears are pointed rather...
Vocabulary. A monomial is an expression that is either a number, a variable, or the product of a number and one or more variables.. A . binomial. is the sum of two monomials. A . trinomial. is the sum of...
Ready to download the document? Go ahead and hit continue!