Results 1 to 2 of 2

Thread: Design Feedback

  1. #1
    Join Date
    Nov 2015

    Unanswered: Design Feedback

    Our accounting software is awful and I need a way to track purchases for a multitude of reasons. It has been 10 years since I took a DB design class. Does the attached image look like an efficient design that won't break anything?
    DanClick image for larger version. 

Name:	Design.png 
Views:	4 
Size:	30.0 KB 
ID:	16630

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    so in this school you raise a single purchase request per single product bought, so you can't have a PRN (purchase Request Note) which orders a block of stuff
    I woudl then expect a PRN to explode into actual orders placed with supplier(s). a PRN may well explode in orders with multiple suppliers. similarly an order with a supplier may also be a composite of several PRN's (assuming the process model allows it). if your process model is one order per destination (ie you can't add more than one schools PRN's into one physical order then dont do it)

    there can only be one supplier of a specific product bought

    there is no concept of equivalence (ie manufactuer A sells 'superbright Letter', manufacturer B sells 'value Letter' paper both are the same weight and same suitability for ink or laser or photocopier....)
    there is no concept of part deliveries (ie supplier A delivers 10 reams Letter paper, this week and another 40 next week which are all part of the same order

    I woudl have expected the actual purchases to reflect the school that requested the item not the requestor, or perhaps both.

    is it a real attempt at a real system or is it slightly masked homework?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts