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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-22-08, 14:35
Heminem Heminem is offline
Registered User
 
Join Date: Jul 2008
Posts: 12
Project Management 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.

A project is done for one Client Company; a Client company can have multiple projects.
Client Companies can be represented by multiple contacts (individuals). A contact can only represent one Client company.
Client Companies can have multiple Prime client contacts (individuals). A Prime client contact can only represent one Client company.
A Project can have multiple Client contacts and an individual Client contact can be related to multiple projects.
A Project can have only one Client contact as the Prime Client contact. A Client contact can be the prime Client contact for multiple projects.
A Client contact can or can’t be a prime Client contact. A prime Client contact has to be a Client contact.


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 client it's being done for, and the Prime client contact.
The second Query will ask for All the Client contacts that were involved in a certain Project.
Does my diagrams cover these?
Attached Files
File Type: doc PMD - ER diagram (client).doc (33.0 KB, 98 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