data flow diagram

Posted on 2006-05-08
Medium Priority
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 600 total points
ID: 16630705
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

GRayL earned 600 total points
ID: 16632489
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
ID: 16879582

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

ID: 16962599
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

616 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