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  dBforums > General > Database Concepts & Design > Project Management Database Part 2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-22-08, 14:44
Heminem Heminem is offline
Registered User
 
Join Date: Jul 2008
Posts: 12
Project Management Database Part 2

This is the second PArt of the same database.
These are the relationships I am trying to catch in my diagram. I would like you guys to check my diagram to see if I have covered them all.

Consultant Relations
A project can have many consultant companies; A consultant company can do many projects.
A Project can have only one Consultant Company as the Prime Consultant Company. A Consultant Company can be the Prime Consultant Company for multiple projects.
Consultant Companies can be represented by multiple Consultant contacts (individuals). A Consultant contact can only represent one company
A Project can have multiple Consultant contacts and an individual Consultant contact can be related to multiple projects.
A Project can have only one Consultant contact as the Prime Consultant contact. A Consultant contact can be the prime Consultant contact for multiple projects.
A Consultant contact can or can’t be a prime Consultant contact. A prime Consultant contact has to be a Consultant contact.
A Consultant company can have many Prime Consultant contacts. A Prime Consultant contact can only be part of one Consultant company.
A Prime Consultant company can have many Prime Consultant contacts. A Prime Consultant contact can only be part of one Prime Consultant company.
Many of the Consultant Contacts can be Prime consultant contacts for different projects.

Finally one of the most important query that I will be making with these is A profile sheet that will give back project info, the Prime Consultant Company info, and the Prime consultant contact info.
The second Query will ask for All the Consultant contacts that were involved in a certain Project.
Does my diagrams cover these?
Attached Files
File Type: doc PMD - ER diagram (Consultant).doc (37.0 KB, 84 views)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On