Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    28

    design databrase about business sale

    i don't know how to call it.
    it's business sale
    special : customer have point. please download picture
    one customer have only 2 customer

    when customer4 sale product form me . point of product will share give point to customer2 and customer1



    or when customer3 sale product from me. point of product will give only point to customer1

    sorry if i say difficult.

    i'm so sorry if you don't understand me
    Attached Thumbnails Attached Thumbnails relation.JPG  

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Please see if I understand you correctly. Is this essentially a multi-level marketing scheme? The members (you call them customers) are arranged in a binary tree, so that there are two descendants from each customer. When a customer makes a sale, you want to reward their ancestors in the tree.

    Do you reward all ancestors, or is there some limit to how many customers participate in a given transaction? Is the reward the same for all the customer ancestors, or do different ancestors get different rewards?

    Some database engines can handle this problem directly with a single statement, others need compound statements or even scripts to do this. What database do you plan to use?

    -PatP

  3. #3
    Join Date
    Aug 2008
    Posts
    28
    i want to use SQL server 2005

    how do you design this database?

    how do international programmer design this style database?

    i use vb.net 2005 to write program.

    i ever design it but i think it was difficult for write code

    can you help me ?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    You need to answer the two questions I asked so that I can help you.
    Quote Originally Posted by Pat Phelan
    Do you reward all ancestors, or is there some limit to how many customers participate in a given transaction? Is the reward the same for all the customer ancestors, or do different ancestors get different rewards?
    -PatP

  5. #5
    Join Date
    Aug 2008
    Posts
    28
    "Do you reward all ancestors" -> reward only ancestor

    "Is the reward the same for all the customer ancestors, or do different ancestors get different rewards?" -> the reward the same for the member

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •