<div>
That's absolutely awesome, thanks a million for taking the time to write such a detailed response. &nbsp;Very very much appreciated!<br />
<br />
:)
</div>


That's absolutely awesome, thanks a million for taking the time to write such a detailed response.  Very very much appreciated!

:)

<div>
<div class="content wysiwyg-content">
Hi<br />
Is there anywhere that I can get help modelling my system into an efficient database model? &nbsp;I have tried a number of times to design out the tables and relationships but keep getting mixed up and running into problems. &nbsp;I shall post the outline here and any help or advice would be very much appreciated.<br />
<br />
I have a stock room with items of stock.<br />
These items of stock are used to create sets of product which are then shipped.<br />
Given the length of the final product, I can make a judgement on the amount of each product a set that will be shipped, however this is not fixed.<br />
Stock items can also be sold individually.<br />
<br />
I receive an order from the sales department detailing the qty and lengths of sets to send. &nbsp;These orders can also, as stated before, be for individual items. ie not in sets / spares<br />
<br />
I would like to be able to add sets to the database and edit the stock items and quantities associated with each set as I go.<br />
<br />
Any ideas?<br />
<br />
Thanks<br />
<br />
Shane
</div>
</div>


Hi
Is there anywhere that I can get help modelling my system into an efficient database model?  I have tried a number of times to design out the tables and relationships but keep getting mixed up and running into problems.  I shall post the outline here and any help or advice would be very much appreciated.

I have a stock room with items of stock.
These items of stock are used to create sets of product which are then shipped.
Given the length of the final product, I can make a judgement on the amount of each product a set that will be shipped, however this is not fixed.
Stock items can also be sold individually.

I receive an order from the sales department detailing the qty and lengths of sets to send.  These orders can also, as stated before, be for individual items. ie not in sets / spares

I would like to be able to add sets to the database and edit the stock items and quantities associated with each set as I go.

Any ideas?

Thanks

Shane

RDBS Data Modeling

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.