we have customer who want to make some product like this or more specifically she needs replica of this product which is a generic inventory,product,customer etc management system. And the reqirement document she sends contains just module names like

1. Inventory Management
2.  Order Management
3.  Vendor Management
4.  Customer Management
5.  Front E-Commerce Store
6.  Online Purchase Orders
7.  Payment Integrations
8.  Products Management
9.  Shipping Management

Being a database designer how to model these things as i don't have any clear requirements document. From where should i start to go into he right direction. Any suggestions?

closed as too broad by Mark Storey-Smith, Mat, Paul White, ypercubeᵀᴹ, RolandoMySQLDBA Sep 24 '14 at 14:49

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    Ask the client? I mean...how exactly do you expect us to guess the client's requirements any better than you?! – Mark Sinkinson Sep 24 '14 at 8:44
  • Requirement is to make replica of above mentioned system. – james Sep 24 '14 at 9:04
  • If you don't know what she wants, and she doesn't know what she wants, then I'd recommend you both save time and money and just buy her a license for TradeGecko. Because no one here can help you... – Mark Sinkinson Sep 24 '14 at 9:07
  • what will you do if you have been asked to make replica of some application at very high cost? – james Sep 24 '14 at 9:12
  • 3
    That book may help once you have requirements, but you must have a better set of requirements before you can even start. Your client needs some proper business analysis work done to establish what they need the resulting system to achieve (outputs, user stories and processes, inputs). Don't try do this BA work for them (certainly not for free) - it can be very time consuming and is going to need some experience if the client really doesn't currently know what they want in any detail other then "something like this <points>". – David Spillett Sep 24 '14 at 9:39

Unfortunately your link prompts me to create an account. Anyhow, she wants a system which handles her universal business processes. Looking at the modules she wants, these are very generic modules, so a lot of options can be used. Unless there are no very specific needs - business processes and business rules that deviates from the universal business processes, or a specific database structure due to the exchange with more other database systems - I don't recommend you to reinvent the wheel. In case you still wonder how you could create your own universal model, or just grab information out of it, Data Model Patterns by David C Hay is a great informative book.

My personal choice would be to do a good research in business-to-business application solutions or other open source universal database models, I'm sure there are plenty to find, then alter the database on eventual specific needs of your client.

Not the answer you're looking for? Browse other questions tagged or ask your own question.