How to create good database design using sql-server and asp.net? : <p>Right now, I'm learning all about database design. Basically the contents of my database are brands for musical instruments. And there are two types of musical instruments which is Guitar and Bass. Now, I have stumbled upon a problem where sometimes a brand would have two types. Like for example in the table below, as you can see the ibanez is repeated twice so that it can accomodate both guitar and bass. I was advised to never repeat data in database but I haven't thought of a solution for this yet.</p>

<p>brandId&nbsp;&nbsp;type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;image
<br/>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Guitar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ibanez&nbsp;&nbsp;&nbsp;&nbsp;xyz.jpg
<br/>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bass&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ibanez&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hyz.jpg
<br/>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Guitar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fender&nbsp;&nbsp;&nbsp;&nbsp;abc.jpg
<br/>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bass&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fender&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fgh.jpg
<br/>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Guitar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yui.jpg
<br/>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Guitar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mbm.jpg
<br/>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bass&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Warwick&nbsp;&nbsp;&nbsp;&nbsp;omo.jpg</p>

<p>When i want to display the brand images in my webpage whether its for guitar or bass, i would normally use this query in asp.net.</p>

<pre><code>public List&lt;brand&gt; GetBrandData()
{
    MusicStoreDBEntities obj = new MusicStoreDBEntities();
    List&lt;brand&gt; list = new List&lt;brand&gt;();
    list = (from g in obj.brands where g.type=="Guitar" select g).ToList();

    return list;

}
</code></pre>

<p>I wanted to know if there are any alternative database design approach where i don't need to repeat data. Kindly provide better solutions or better query in asp.net and hopefully with actual examples.</p>
