Simple retail(store)database design RSS

• • Reply
  

  hady_matrix

  Member

  244 Points

  253 Posts

  Simple retail(store)database design

  Dec 06, 2012 05:00 PM|LINK

  hi all,

  i want to make a software application to manage a store..

  start from making po(purchase oredr) of Products(Items)from a vendor then start selling to customers.

  could you advice me about my database design as below. and the best pracise for this kind of database.

  where:

  POHeader:purchase order

  PODetails:details of purchase order

  SOHeader:sold items

  SODetails:sold items details

  thanks so much

  

  http://www.rasoulallah.net/index_english.asp
• • Reply
  

  Chen Yu - MS...

  All-Star

  21829 Points

  2513 Posts

  Microsoft

  Re: Simple retail(store)database design

  Dec 07, 2012 07:20 AM|LINK

  Hi,

  Would you please tell us the current relationships along those tables and the requirements you need?

  You could follow below article's tips to build your table relationships.

  Please see: http://www.codeproject.com/Articles/359654/11-important-database-designing-rules-which-I-foll 

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
• • Reply
  

  hady_matrix

  Member

  244 Points

  253 Posts

  Re: Simple retail(store)database design

  Dec 10, 2012 09:44 PM|LINK

  the main problem here the analysis not database design.

  i need your advice about this kind of system .how to design the best preactise?

  could you list me the tables to design this system?

  thanks

  http://www.rasoulallah.net/index_english.asp