Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 954
  • Last Modified:

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

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
wescs
Asked:
wescs
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<< 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now