Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011

    Data recording keeping for different sale method


    I'm working on a project where a company has two forms of sales- direct sales to retailers and customers through website. The company doesn't record similar data for the two forms of sales. My question is: Do I have to create two separate tables for the two different methods of sales? Also, for the ERD, is this structure a correct way to design the process?

    Sales Order ----> Direct sales (one table), Sales to customers (separate table) ----> Cash Receipt

    Thanks for you help!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    a sale is a sale,whether its over the counter or on a website.
    you don't need two separate entities, however if there are significant diffenrecs you may need three tables usign the sub/supertype approach. that you be one table for the common items, and two sub / child tables for whats different between the two. ferinstance taht could be things like delivery address, invoice address, email for the web sale.

    plenty would argue that unless you have some significant diferences a single table woudl suffice.

    its a quite a common approach and its mirrored by the real world. OK its not the same but
    many shops only sell on account administratively so any sales over the counter are assigned to an account. if the customer doesn't have an account then the organisation registers those sales to a generic account called cash account or counter sales / whatever. in principle your requirement is similar
    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