Jump to content
warrencec

Hello all.

Recommended Posts

I am new to database design, still trying to ease into it, there is one example I am working on, but having difficulty due to me being a newbie. 
Please find attached the scenario, and what I’ve got so far.
can you please help me with what the exact modeling should be for this scenario?
 
 
 
 
Thank you in advance,
 
warrence

Document Tracker System.doc

Document Tracker System1.zip

tables.doc

Link to post
Share on other sites

its the routing(Entity) part(views) that i dont know how to go about, how to break it down.

how to make the routing path and Tracking from one person to another. As there suppose to be a routing guideline, internal and external routing path.
I am thinking for example ,Lets say a document ,documentId 12345 , of documentType 789, have to go through these 5 person.

STOPS
 1 -----------------------> 2 -------------------------> 3 --------------------------> 4 ------------------------> 5
Officer2                 Officer3                         Officer5                        Officer1                        Officer8
 

how do i go about making a view for that from the routing entity, how do i split it into tables.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...