title: Need advice for Database structure (MS SQL / MySQL)
body: <p>Preferrably MS SQL, I want to make the switch over from MySql.</p>
  
  <p>So I have this awesome customer who has 4 Excel Files. Each Excel file represents a <code>Product Range</code>.</p>
  
  <p>Within each Excel File, there are between 3 to 8 Sheets. Each <code>Sheet</code> representing a <code>Type</code> of <code>Product</code> within that <code>Product Range</code>.</p>
  
  <p>Each Sheet, contains the following Columns:</p>
  
  <p><code>PartNo</code>, <code>Description</code>, <code>QTY</code>, <code>Price1</code>, <code>Price2</code>, <code>Price3</code>, <code>Price4</code>...</p>
  
  <p>(There's never been, and won't be any more than 8 Price Columns.)</p>
  
  <p>Each Sheet may contain from about <code>5</code> to <code>5000</code> rows.</p>
  
  <p>Now, the problem I am facing now, is not knowing which would be the best way to go about setting up my new Database.</p>
  
  <p>The way I currently have our existing MySQL Database is each Sheet represents a Table. That's it! <em>(It had to be put "out there" quickly, hence the lack of time invested into setting up a proper format/structure for the DB.)</em></p>
  
  <p>I've recently found that I am much more competent using <code>MSSQL</code> databases, so I want to make the switch, and the second reason, the main reason, is because I want to restructure the Database so I can make things easier to manage, and make it easier to setup Database searches from my site.</p>
  
  <p>I'm not worried at all about How to insert everything into the database, as in my spare time for the last year I've written an app that parses these Excel files, extracts the sheets, and inserts them into the DB, with optional settings. I am worried about <strong>how</strong> I should actually setup this new DB.</p>
  
  <p>What would be the best way to go about this given the above details?</p>
  
  <p>Any help at all is greatly appreciated. Thank you!</p>
  
  <h3>Update:</h3>
  
  <p>About the Pricing Columns (Example), a little info on <em>why</em> there are more than one price columns in each sheet.:</p>
  
  <p>Price column 1 may be Galvanised Unit Price, Price Column 2 may be Galvanised Box Price, Price Column 3 may be Stainless Steel GR304 Box Price, while column 4 may be Stainless Steel GR316 Unit Price. These price columns are different for each Product Range, however, some products in a Product Range may also contain some of the same Price Columns. This is why it was so easy to have each product as a separate table.</p>