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 > ownership of records in a contact database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-30-04, 11:58
rreid rreid is offline
Registered User
 
Join Date: Jul 2004
Posts: 2
ownership of records in a contact database

Hi,
I'm making a design decision about a database that stores contact info (name, address, phone, etc) amongst other things. The contacts are members of one or more of our organization's "networks" (i.e. mailing lists). There's one staff member here in charge of each network.

I need to decide whether each contact should have one owner (i.e. one staff member allowed to edit the contact info), or if I should allow one staff person from each network to modify the contact info (with email notification to other owners), even if this means that an individual contact has several owners. Any suggestions on what works best in practice?
Reply With Quote
  #2 (permalink)  
Old 07-30-04, 23:34
certus certus is offline
Registered User
 
Join Date: Dec 2003
Location: Canada
Posts: 710
The problem you're presenting is really about business rules. This is a job for an analyst working with the client. The business rules the analyst comes up with are then incorporated into the design.

If you are the one doing the analysis stop designing, pull your clients together present your case and let them provide the answer.

That would be the industry standard approach.
__________________
visit: relationary
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