If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Can someone have a look at this please?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-29-10, 16:47
Frunkie Frunkie is offline
Gives Bad Advice
 
Join Date: Mar 2007
Location: 010101010110100
Posts: 791
Can someone have a look at this please?

I've not designed a point of sale before and frankly, don't have much knowledge of what attributes are needed. I found the following schema and realized that it still won't store everything I need; I'm still missing some attributes.

Some of the issues that I see with this digram:
  1. I need to allow for product returns.
  2. I need to allow no charge items.
  3. There should be an allowable discount for each product and also an additional discount that can be applied at check out.
  4. The pos_invoice table doesn't have a total attribute.
  5. How to handle voided transactions...

I think I can add a total column to the invoice table but I'm wondering why it wasn't there to begin with. So where should these attributes go?

Last edited by Frunkie; 12-03-10 at 20:43.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On