warrencec Posted August 18, 2014 Share Posted August 18, 2014 hello all, i am from seychelles, newbie in database designs. would like some help and pointers on a training design am working on. Quote Link to comment Share on other sites More sharing options...
Administrators Nathan Posted August 19, 2014 Administrators Share Posted August 19, 2014 Happy to help, post up your questions. Quote Link to comment Share on other sites More sharing options...
warrencec Posted August 19, 2014 Author Share Posted August 19, 2014 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 Quote Link to comment Share on other sites More sharing options...
Administrators Nathan Posted August 19, 2014 Administrators Share Posted August 19, 2014 A little bigger than a small startup project. No problems though. I'm looking through the tables.doc I don't see any issues there, what's the problem with it? Quote Link to comment Share on other sites More sharing options...
warrencec Posted August 20, 2014 Author Share Posted August 20, 2014 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 ------------------------> 5Officer2 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. Quote Link to comment Share on other sites More sharing options...
Lizel Posted February 22, 2015 Share Posted February 22, 2015 Hello Seychelles.That's a nice name you've got, very unique, I'd say. Welcome here and hope that you will like your stay in this wonderful community. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.