Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Help with Inventory Database Design

    We are looking at two options for inventory design. I wanted to get some opinions about both options. To give you a little background; this is a retail system, which users can buy and sell unique items - Coins, Currency, Bullion, and Books.

    We have Type Set reference tables for Coins, Currency, Bullion, and, books. These tables contain predefined attribute values based on unique number or type. These reference tables allows users to quickly input a unique number and pre-populate the inventory entry screen with the predefined item's attribute.

    Now, for storing the inventory record in the database. We can either do, Option #1 - We record items attribute values pulled from the typed reference tables or Option #2 - we store the primary Key ID from that typed reference table.

    Any comments or opions would be appreciated.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'd go for option 2, although you did not really give us very good examples to work from
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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