Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nraina
Starting Member
2 Posts |
 Posted - 2011-05-24 : 07:27:45
|
 This is ER Diagram of POS that I've made it has been made simple. I just want you to tell is there anything wrong in my ER Diagram and what else modules can I add while keeping the overall Design simple. |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-05-24 : 14:20:51
|
| I don't see anything wrong. But you may wish to consider eliminating the Purchase History. That information should exist in the Purchase Order/ Detail. Having the Purchase Order History means you will have to update the Data in 2 places. You may wish to add a shipping module or at least add a Ship Date somewhere. |
 |
|
|
nraina
Starting Member
2 Posts |
Posted - 2011-05-25 : 00:59:49
|
quote:
Originally posted by denis_the_thief
I don't see anything wrong. But you may wish to consider eliminating the Purchase History. That information should exist in the Purchase Order/ Detail. Having the Purchase Order History means you will have to update the Data in 2 places. You may wish to add a shipping module or at least add a Ship Date somewhere.
Well Thanks for your reply. actually Purchase History I've added is basically for reporting purpose but yes thats true I'll have to add data in both places thats weird. I'll remove Purchase History and will add up the Dealer ID to Purchase Order Detail for reporting.And regarding the shipping module, thanks for suggesting, what attributes can I have if I made a separate module for that one. |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-05-25 : 10:17:49
|
| For Shipping, if you can have partial shipments, i.e. Order 10, 5 are ready, ship 5 now, ship 5 later - then you'll need a module like Ship date, Qty, Item ID, Ship Method. Otherwise you might not need a module, just add ship date and ship method (i.e. Mail, Truck, who's delivering it).In terms of Reporting, sometimes that is done, a special table(s) that may make reporting easier but this has to be considered your efforts in keeping it updated, unless your system gets more complex, I would likely leave it out. |
|
|
|
|
|
|
|
|
Need Help in POS ER Diagram