Looking for BOM table structure design 1

[johnk]

Although I have used chain files to define bill of materials relationships in an earlier programming life, I would appreciate any suggestions for practical table relationships in an RDMS.

John Kisner

 

[tlbroadbent]

Here are some helpful links.

Expanding Hierarchies (SQL BOL)

http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_14_5yk3.asp

Working with hierarchical data in SQL Server databases

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

More Trees & Hierarchies in SQL

http://www.sqlteam.com/item.asp?ItemID=8866

Trees in SQL- SearchDatabase

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html

Converting an adjacency list model to a nested set model

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html

Trees in SQL - Intelligent Enterprise

http://www.intelligententerprise.com/001020/celko.shtml

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm