If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > New Members & Introductions > Help with dfd & erd

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-13-11, 14:20
dankkinh dankkinh is offline
Registered User
 
Join Date: Oct 2010
Posts: 6
Help with dfd & erd

Ok so I am creating something in Visual Basic that will allow for my boss to input information about a customer and the project that the customer wants completed. The data will then be distributed into a database.

So you know what you are looking at in the pictures, the company I work for does parking lot maintenance. We do asphalt repair, crack filling, seal coating, and line striping. The pictures below show the ERD and DFD that i created.

Is the ERD constructed properly? Are the relationships and primary/foreign keys correct? Is it in 3NF?

And for the DFD I would like to know if the processes and the data flow terms are correct.

Thank you in advance, I really appreciate any of the suggestions and help.
Attached Thumbnails
Help with dfd & erd-dfd.png   Help with dfd & erd-erd.png  
Reply With Quote
  #2 (permalink)  
Old 01-13-11, 15:12
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
the dfd seems incomplete -- the customer only ever requests and receives a quote

more specifically, the customer never surrenders any information that can be added to the database, and the customer never initiates anything after receiving an agreeable quote

are you sure this isn't a homework assignment? most small businesses have never even heard of dfds and erds, let alone require someone to produce them before building an app
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 01-13-11, 15:31
dankkinh dankkinh is offline
Registered User
 
Join Date: Oct 2010
Posts: 6
Sorry I should have stated that it is a homework assignment but I am really implementing this for the business. What would help complete the DFD? How would I add a data flow for changes to be made or for the customer to agree to the quote submitted?
Reply With Quote
  #4 (permalink)  
Old 01-16-11, 21:43
dankkinh dankkinh is offline
Registered User
 
Join Date: Oct 2010
Posts: 6
Can anyone help me out?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On