<div>
Have you Googled around?<br />
<br />
First link got me here:<br />
<a href="http://allenbrowne.com/AppInventory.html" rel="ugc">http://allenbrowne.com/AppInventory.html</a><br />
<br />
Second:<br />
<a href="http://books.google.com/books?id=O3Qdc2yb_JoC&pg=PA215&lpg=PA215&dq=raw+material+database+design&source=bl&ots=Oys4dXwPj3&sig=he8wG97JvfFIxhQNo2UlonloirI&hl=en&ei=vCB5TevIOsKV0QH9y_jPAw&sa=X&oi=book_result&ct=result&resnum=2&ved=0CCYQ6AEwAQ#v=onepage&q&f=false" rel="ugc">http://books.google.com/books?id=O3Qdc2yb_JoC&pg=PA215&lpg=PA215&dq=raw+material+database+design&source=bl&ots=Oys4dXwPj3&sig=he8wG97JvfFIxhQNo2UlonloirI&hl=en&ei=vCB5TevIOsKV0QH9y_jPAw&sa=X&oi=book_result&ct=result&resnum=2&ved=0CCYQ6AEwAQ#v=onepage&q&f=false</a>
</div>


Have you Googled around?

First link got me here:
http://allenbrowne.com/AppInventory.html [http://allenbrowne.com/AppInventory.html]

Second:
http://books.google.com/books?id=O3Qdc2yb_JoC&pg=PA215&lpg=PA215&dq=raw+material+database+design&source=bl&ots=Oys4dXwPj3&sig=he8wG97JvfFIxhQNo2UlonloirI&hl=en&ei=vCB5TevIOsKV0QH9y_jPAw&sa=X&oi=book_result&ct=result&resnum=2&ved=0CCYQ6AEwAQ#v=onepage&q&f=false [http://books.google.com/books?id=O3Qdc2yb_JoC&pg=PA215&lpg=PA215&dq=raw+material+database+design&source=bl&ots=Oys4dXwPj3&sig=he8wG97JvfFIxhQNo2UlonloirI&hl=en&ei=vCB5TevIOsKV0QH9y_jPAw&sa=X&oi=book_result&ct=result&resnum=2&ved=0CCYQ6AEwAQ#v=onepage&q&f=false]

<div>
hi slightwv,<br />
<br />
could u pls. clear some doubts?<br />
<br />
I have a raw material named aluminium steel for eg. the thickness is 5mm lenght and width is 200cm x 200cm. How can I create stock table to store the quanity of al. sheets? If I recieve 2 sheets from a supplier, how can update the stock quantity in the stock table? another raw material's unit is diameter etc.<br />
<br />
pls. hlep<br />
<br />
thanks
</div>


hi slightwv,

could u pls. clear some doubts?

I have a raw material named aluminium steel for eg. the thickness is 5mm lenght and width is 200cm x 200cm. How can I create stock table to store the quanity of al. sheets? If I recieve 2 sheets from a supplier, how can update the stock quantity in the stock table? another raw material's unit is diameter etc.

pls. hlep

thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Please provide a sample database to deal with Raw Materials inventory and Bill Of Material.<br />
<br />
Thanks<br />
<br />
Ayha
</div>
</div>


Hi,

Please provide a sample database to deal with Raw Materials inventory and Bill Of Material.

Thanks

Ayha

database sample

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.