<div>Hi Dave</div>
<div>I am not sure if I understood your suggestion properly. I am writing below my understanding.</div>
<div>I have given the table example below, if wrong, please correct me.</div>
<div> </div>
<div>Please see my response inline.</div>
<div> </div>
<div>Regards</div>
<div>Kamal</div>
<div> </div>
<div class="gmail_quote">On Fri, Mar 25, 2011 at 9:48 PM, Metzler, David <span dir="ltr"><<a href="mailto:metzlerd@evergreen.edu" target="_blank">metzlerd@evergreen.edu</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="blue" link="blue">
<div>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Think about how you would write a query to say who has the skill set x? You can’t really do it, cause you’ve got to change what table you select based on what you’re looking for? How much php code will you have to change to a). Add a skill set? B.) add a work domain? </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Rather design a table for user skill sets with the columns:</span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Uid, skill_set_id</span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p></div></div></blockquote>
<div> </div>
<div>So the table will look as below.</div>
<div> </div>
<div>
<table style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="384">
<colgroup>
<col style="WIDTH: 48pt" span="6" width="64">
<tbody>
<tr style="MIN-HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 15pt; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="20" width="64"><strong><font face="Calibri">UID</font></strong></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="64"><strong><font face="Calibri">PHP</font></strong></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="64"><strong><font face="Calibri">HTML</font></strong></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="64"><strong><font face="Calibri">VOIP</font></strong></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="64"><strong><font face="Calibri">SQL</font></strong></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="64"><strong><font face="Calibri">MYSQL</font></strong></td></tr>
<tr style="MIN-HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="20"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td></tr>
<tr style="MIN-HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="20"><font face="Calibri">2</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td></tr>
<tr style="MIN-HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="20"><font face="Calibri">3</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td></tr>
<tr style="MIN-HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="20"><font face="Calibri">4</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"><font face="Calibri">0</font></td></tr></tbody></colgroup></table></div>
<div> </div>
<div> </div>
<div>If this is the case, table coulmn will keep increasing.</div>
<div> </div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="blue" link="blue">
<div>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">And a lookup table to define skill sets and their categories and their relavent work domains: </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Skill_set_id, skill_set_descr, work_domain</span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p></div></div></blockquote>
<div> </div>
<div>Is this example holds good?</div>
<div> </div>
<div>
<table style="WIDTH: 233pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="310">
<colgroup>
<col style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width="77">
<col style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width="124">
<col style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width="109">
<tbody>
<tr style="HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="20" width="77"><font face="Calibri">Skill ID</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Skill desc</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">work domain</font></td></tr>
<tr style="HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="20" width="77"><font face="Calibri">PHP</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Good in PHP</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">Web</font></td></tr>
<tr style="HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 30pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="40" width="77"><font face="Calibri">HTML</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Average in HTML</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">Web</font></td></tr>
<tr style="HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 30pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="40" width="77"><font face="Calibri">VOIP</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Average in VoIP</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">VoIP</font></td></tr>
<tr style="HEIGHT: 15pt" height="20">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="20" width="77"><font face="Calibri">SQL</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Good in SQL</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">Database</font></td></tr>
<tr style="HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; HEIGHT: 30pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" height="40" width="77"><font face="Calibri">MYSQL</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 93pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="124"><font face="Calibri">Good in MySql</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="109"><font face="Calibri">Database</font></td></tr></tbody></colgroup></table>
</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="blue" link="blue">
<div>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">If you need to create 50 tables for modeling a concept you probably aren’t normalized. There are other approaches, but this is probably the simplest. </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">Dave</span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<p class="MsoNormal"><font color="navy" size="2" face="Arial"><span style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"> </span></font></p>
<div>
<div style="TEXT-ALIGN: center" class="MsoNormal" align="center"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</span></font></b><font size="2" face="Tahoma"><span style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> <a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>] <b><span style="FONT-WEIGHT: bold">On Behalf Of </span></b>Austin Einter<br>
<b><span style="FONT-WEIGHT: bold">Sent:</span></b> Thursday, March 24, 2011 6:58 PM<br><b><span style="FONT-WEIGHT: bold">To:</span></b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a>; <a href="mailto:pierre.rineau@makina-corpus.com" target="_blank">pierre.rineau@makina-corpus.com</a>
<div><br><b><span style="FONT-WEIGHT: bold">Subject:</span></b> Re: [support] Doubt on Index and Primary key</div></span></font>
<p></p>
<p></p>
<p></p></p></div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Hi Pierre, David, Ursula</span></font></p></div>
<div>
<div></div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Thanks for excellent piece of information. I just went through basic database concepts like indexing, join, normalisation and tried to analyse how can I apply these for my job registration site implementation.</span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">After understanding a bit on normalisation and join, I have comeup with below approach for this specific case.</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Instead of having a single table, and comma separated values in table cells , I am going to split it multiple tables.</span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">I am attaching a table.xls file , please have a look. </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">In that excel sheet, I have the main table, and I have broken the main table into 9 different tables. But I hope it need to be broken into more number of tables, depends on how many different kind of work domains are there. It may go to 50+ tables.</span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Examples for work domains are - Web, PSTN, VoIP, NetworkManagement, GSM, Datbase, BoardDesign etc.</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">So how many work domains are there, those many tables will be there. In those tables, a coulmn will represent a particular skill set.</span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Say under Web Tables, coulmns can be HTML, PHP, Web2.0, Drupal, ASP, etc</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">And under NetworkManagement table, NMS and SNMP can be coulmns.</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">In table cells, I will keep either 1 or 0, depending on the person has that skill or not.</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> Example: Lets say User 2 knows NMS and SNMP, User 3 knows only SNMP, User4 knows only SNMP, then the table will look as below.</span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<table style="WIDTH: 223pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="297">
<colgroup>
<col style="WIDTH: 95pt" width="126">
<col style="WIDTH: 64pt" span="2" width="85">
<tbody>
<tr style="MIN-HEIGHT: 16.5pt" height="22">
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: #17375d 1.5pt solid; PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 95pt; PADDING-RIGHT: 0in; BACKGROUND: #dbe5f1; BORDER-TOP: #17375d 1.5pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 0in" bgcolor="#dbe5f1" height="22" width="127">
<p class="MsoNormal"><strong><b><font color="red" size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; COLOR: red; FONT-SIZE: 12pt">UID</span></font></b></strong></p></td>
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BACKGROUND: #dbe5f1; BORDER-TOP: #17375d 1.5pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 0in" bgcolor="#dbe5f1" height="22" width="85">
<p class="MsoNormal"><font color="red" size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; COLOR: red; FONT-SIZE: 12pt">NMS</span></font></p></td>
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BACKGROUND: #dbe5f1; BORDER-TOP: #17375d 1.5pt solid; BORDER-RIGHT: #17375d 1.5pt solid; PADDING-TOP: 0in" bgcolor="#dbe5f1" height="22" width="85">
<p class="MsoNormal"><font color="red" size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; COLOR: red; FONT-SIZE: 12pt">SNMP</span></font></p></td></tr>
<tr style="MIN-HEIGHT: 16.5pt" height="22">
<td style="BORDER-BOTTOM: medium none; BORDER-LEFT: #17375d 1.5pt solid; PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 95pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in" height="22" width="127">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">2</span></font></p></td>
<td style="PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; PADDING-TOP: 0in" height="22" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">1</span></font></p></td>
<td style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 16.5pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: #17375d 1.5pt solid; PADDING-TOP: 0in" height="22" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">1</span></font></p></td></tr>
<tr style="MIN-HEIGHT: 15.75pt" height="21">
<td style="BORDER-BOTTOM: medium none; BORDER-LEFT: #17375d 1.5pt solid; PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 95pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in" height="21" width="127">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">3</span></font></p></td>
<td style="PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; PADDING-TOP: 0in" height="21" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">0</span></font></p></td>
<td style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: #17375d 1.5pt solid; PADDING-TOP: 0in" height="21" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">1</span></font></p></td></tr>
<tr style="MIN-HEIGHT: 15.75pt" height="21">
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: #17375d 1.5pt solid; PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 95pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in" height="21" width="127">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">4</span></font></p></td>
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in" height="21" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">0</span></font></p></td>
<td style="BORDER-BOTTOM: #17375d 1.5pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; MIN-HEIGHT: 15.75pt; PADDING-LEFT: 0in; WIDTH: 64pt; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: #17375d 1.5pt solid; PADDING-TOP: 0in" height="21" width="85">
<p class="MsoNormal"><font size="3" face="Calibri"><span style="FONT-FAMILY: Calibri; FONT-SIZE: 12pt">1</span></font></p></td></tr></tbody></colgroup></table></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">As first time I am doing this, I might be wrong. If so, kindly let me know.</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Best Regards</span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Austin</span></font>.</p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"><br><br> </span></font></p></div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">On Fri, Mar 18, 2011 at 8:54 PM, Pierre Rineau <<a href="mailto:pierre.rineau@makina-corpus.com" target="_blank">pierre.rineau@makina-corpus.com</a>> wrote:</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Le vendredi 18 mars 2011 à 08:15 -0700, Metzler, David a écrit :</span></font></p>
<div>
<p style="MARGIN-BOTTOM: 12pt" class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">> Pierre is spot on here.<br>><br>> That is why most dbas would advise against storing this data in a comma separated list in a single field. An index cannot really be used to search within the text cause you are forcing to examine every row anyway. I can't programtically say lets start with the N's, now is there a nokia in there (that's an oversimplification intentionally to make a point). Rather I would make a single skill table that housed the values. If UID is the primary key for the resume, then you'd make a table with<br>
><br>> On a separate note, you do understand that the site that you're talking about building could be done without you writing ANY code? Basically the site you've described can be implemented with content_profile, cck and views modules, allowing you to build custom content types that are tied (one per user). You could then use taxonomys for skill sets an all this would be written for you?<br>
><br>> Dave</span></font></p></div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt">Dave is right about the fact this simple business stuff could be done in<br>many ways using D6 existing modules (even only with core and taxonomy)<br>
or D7 fields.<br><br>But, if you really want to learn technical aspects of SQL and/or Drupal<br>development, this is a good thing to start with this kind of simple<br>business stuff.</span></font></p>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"><br>Pierre.<br><br><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</span></font></p>
</div></div></div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="FONT-SIZE: 12pt"> </span></font></p></div></div></div></div><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote></div><br>