Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Question database design for range data

    I'm designing database system. How can I design database for storing range data? I need to store shipping cost per unit which depends on number of product shipped. For example,

    Number of product shipped --shipping unit
    1 --$100
    2-3 --$85
    4-6 --$75
    7+ -- $65

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: database design for range data

    Originally posted by ssiriwon
    I'm designing database system. How can I design database for storing range data? I need to store shipping cost per unit which depends on number of product shipped. For example,

    Number of product shipped --shipping unit
    1 --$100
    2-3 --$85
    4-6 --$75
    7+ -- $65
    Num_Shipped_From, Num_Shipped_To, Price
    1, 1, $100
    2, 3, $85
    4, 6, $75
    7, 9999999, $65

    Then for a particular order, you can get price where order_num_shipped BETWEEN num_shipped_from and num_shipped_to.

Posting Permissions

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