Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: BOM Database Design Books/Papers

    Are there any books or papers on database design that explain how to design BOM (Bill of Materials) type of databases.

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Posts
    87

    Re: BOM Database Design Books/Papers

    I've noticed you've no answers yet. Anyway, BOM is done with recursion (some call this a hierarchy) in a RDBMS.
    create table BOMtable (
    BOM_ID number not null PK,
    parentBOM_ID number FK references BOM_ID in BOMtable,
    col3 . . . )

    Originally posted by umranin
    Are there any books or papers on database design that explain how to design BOM (Bill of Materials) type of databases.

    Thanks.
    Oracle - DB2 - MS Access -

  3. #3
    Join Date
    Nov 2003
    Posts
    48
    A good reference is

    "The Data Model Resource Book" Volumn II
    Len Silverston
    Published by Wiley

    You can find BOM data model in the book
    Shianmiin

Posting Permissions

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