Solved

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

Posted on 2004-10-07
3
914 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
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

747 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

9 Experts available now in Live!

Get 1:1 Help Now