Desktop

I don't have any specific titles, but what you want is a book on building relational databases. The purpose of having an ERD or DFD is to deisgn and or explain a complex relationship between multiple tables, schema or databases.

The way I start adataflow diagram is to simply list all the inputs; data entry screens, reports and/or interfaces from other systems etc., on one side of the page, then list the outputs:reports, export files, interfaces which feed other systems, on the other side ofthe page. Then you have to trace a path of how information flows from one side to the other.

Its best to start at the high level, like files and reports, and work your way down to the detail level, like individual fields. When doing that, its best to concentrate on whats required for outputs, and eliminate and fields or inputs which don't impact outputs.


I'm sure there are books out there which may help.

James

Here are some links I found helpful when I was preparing for my MCDBA certification tests last year...

Database Normalization
http://www.wdvl.com/Authoring/DB/Normalization/
http://www.devshed.com/Server_Side/MySQL/Normal/

Entity Relationship Diagrams (ERDs)
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter2/node1.html

Data Flow Diagrams (DFDs)
http://www.aisintl.com/case/dfd.html
http://www.smartdraw.com/resources/centers/software/dfd.htm

For more information, go to http://www.google.com and enter the search phrases in as many variations as you can imagine.
I also reccomend any books (Sybex, ExamPrep(coriolis), MS Press) dealing with the Microsoft SQL tests 70-029(SQL7) or 70-229(SQL2000), they are the design level courses that really drive home the concepts of Normalization and use of DFD's and ERD's in the design stage, where it counts most.

Also, a GREAT resource for what seem like off-the-wall terms at first, yet end up being genuine "geekspeak" is http://www.webopedia.com trust me on this one.

Good luck with your studies, but remember.. you can read about stuff all you want, but there is NO substitute for hands-on experience with the product... I used the 90 day eval copy of SQL server 7 from Microsoft's site to prepare, it was the best training aid, bar none.

This question was closed by the author