Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duleepN
Starting Member
12 Posts |
 Posted - 2008-06-15 : 08:14:46
|
| I want your expert opinion to find out the best design solution to this my current issue.1 . I have a Member Table. These members are sub categorised and again and again. So I have three three category tables which are related and all three tables directly related to the Member table via Foreign keys.IS THIS THE CORRECT DESIGN??2. I Have a SKILLS table where Members can select their SKILLS from that. I record this in a separate table called "MEMBER SKILLS". There is a SKILL category called "OTHER", then the Member can write those skills which may be not listed in the SKILLS table. I have created a separate column in the "MEMBER SKILLS" table it self to record this free text.IS THIS THE CORRECT DESIGN??3. How do you resolve a design issue where there are many nested tables of categories and sub categories and the use can create these categories dynamically as well??I hope all above make sense to you to give a logical answer. Thank you very much for you assistance. |
|
|
duleepN
Starting Member
12 Posts |
Posted - 2008-06-19 : 18:54:03
|
| NO body knows the answer to above or no body bothers to answer or no body can understand the question?? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-19 : 19:06:34
|
| 1. Please provide a data example of what you mean. 2. That sounds fine.3. Please provide a data example of what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Design Issue (Sub Categories and others)