Results 1 to 2 of 2
  1. #1
    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?

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •