A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Table Relationships Design



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 5th, 2004, 12:32 PM
Tom
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.