If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Relationships Design
Via the help of the MS-Newsgroups, I have done some table relationship design in the past. Most previously, I designed
an architeture that uses a) multiple One-To-Many Relationships and b) a Many-To-Many Relationship (via Junction Table). At this time, I am stumped again. Below are a number of tables for which I need to create the relationships. The table names themselves (I hope) kind of describe the nature of the table content. 1. tblBoards 2. tblEmergentTasks 3. tblExperts 4. tblMeetings 5. tlbMembers 6. tblOrganizations 7. tblPlannedTasks 8. tblPriorities Based on the information I have been given by the users, it appears that all of these tables have somehow a Many-To-Many Relationship. For instance, the following are just some thoughts that I have come up with. It does NOT describe the actual relationships between the tables. There will be many boards. Each board may have many organizations. Either board or organization may have many members. The boars will have different priorities. There will be planned and emergent tasks... for all, boards, organizations, members. Multipe experts might attend board sessions or regular scheduled meetings. I truly would appreciate if someone could provide me an idea as to how they should be linked most sufficiently. Somehow I now got "stuck" on the concept of using Junction tables (because it worked out well for me last time). On the other hand, I have looked at the Northwind database sample... with a large number of tables, that db does not use Junction tables at all. Any idea to tackle this would be appreciated!!! Thanks, Tom |
Thread Tools | |
Display Modes | |
|
|