data flow diagram

Posted on 2006-05-08
Last Modified: 2012-08-13
I have recently created a database as an assignment.
It's a standard database for a shop and it consists of the following tables:

tblSupplier,  tblProduct,   tblOrder,  tblOrderDetail,  tblDelivery,  tblDeliveryDetail, tblEmployee,tblClient.

it does all the standard things a database like this is supposed to do i.e. updates, maintains stock and employee/client/supplier details

But now I have been asked to crete a Data Flow Diagram for this thing
and I'm completely at a loss what to do.
I read some material on how to produce these things but I'm bit confused.

Does anyone know how to produce these things, or how to get them?
Question by:ohme
    LVL 84

    Accepted Solution

    There are no native processes you can use in Access to produce these. They're often done with a specific tool designed for that purpose, or by using something like Visio. There are different types as well, for example Physical or Logical/Conceptual.

    Basically, a Data Flow Diagram should show how the data gets from the keyboard to the datastore. Typically you would start where the user begins to enter data - for example this may be when the user enters or finds a customer, followed by entering/finding an order, followed by entering/finding orderitems etc etc ... it should look like a basic "flow chart" which tracks all of these processes and would take the reader in a concrete path from keystroke to data save. Typically these diagrams are not table/field specific - you would not, for example, show exactly what table/field the Customer info is deposited into, but would instead represent that the data is deposited into a datastore of some sort (like a database, file, etc).

    From there you can add any number of things - logic branching, decision cases, etc - if required. Did you receive any further instruction as to exactly what is to be included in your DFD? As you can tell from a quick internet search, there are many different way syou can structure one of these, from a simple table representation (sort of like the Relationships designer in Access) to a full UML-like diagram.

    LVL 44

    Assisted Solution

    While we are not allowed to help you "do" homework, you could try to Google - data flow diagram.  I got more than I wanted to read - a lot of really good stuff.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Microsoft VISO will create the types of diagrams you are looking for.

    However, it won't create then for you automatically.

    Here is a link with lots of helpful information:
    LVL 27

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup topic area:
        Split: LSMConsulting {http:#16630705} & GRayL {http:#16632489}

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    EE Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now