Solved

Formulating DFD's and ERD's in the design phase of a new system

Posted on 2004-10-07
3
925 Views
Last Modified: 2006-11-17
I am currently in a group who is working on a new automated system for a business.  This system will be used for employee shift changes and keep track of these shift changes.  We have formulated the Context Diagram which contains an Employee and Manager entity, and breaks off into one process which is the Shift Change System.  From there we go to the Level 1 Diagram, which again contains an Employee and a Manager entity.  The processes now, in the level one diagram are stumping all of us.  We are confused as to where to go from here, and what should be put in the processes, and what data flow information should go where, and then after the DFD's, how exactly are the ERD's going to be drawn?...Thanks to any and all for any help you can provide.  I really appreciate it.  
0
Comment
Question by:wescs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 12250582
<< Context Diagram, DFD's, ERD's >>

Access isn't exactly a graphics editing program, and will not do Context Diagrams and Data Flow Diagrams for you.  You'll have to make this up using Visio, Excel Drawing, or some other software specifically geared for it.  (Rational Rose?)

Access does have an Entity-Relationship Diagram functionality by clicking on the 'Relationships' button from the Database Window, but all this will do for you is display table names and field names, with lines for relationships.  You can't add text, display data types, etc.

Hope this helps.
-Jim
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

735 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