I think the privacy can be maintained in a single database too. Take for an example, a bank accounts database where privacy is a critical issue. Still, they don't have separate tables for separate customers. We have a unique account number in a common database and still our details cannot be accessed by other customers.
Again, depends on the kind of database management schema you plan to follow, and what are your future plans. I prefer a single database provided the customer information can be standardized. Amrit Hallan ������������������������������������������������������ Web Site Development - http://www.bytesworth.com Copywriting and Copy Editing - http://www.amrithallan.com ������������������������������������������������������ WebDevE-Publication: [EMAIL PROTECTED] ----- Original Message ----- From: "Cheryl D. Wise" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 2:42 AM Subject: [wdvltalk] Re: Question on SQL Server Tables > While from a database perspective it might be better to have one table > from the point of view of the client I'd want my congregation separate > from any other congregations. Sometimes the 'best' practices of database > management are the exact opposite of client management or even legal > obligations. > > You have privacy concerns re the members of each congregation that > outweigh at least to my mind the benefits of 1 database for all clients > separated only by client ID. > > Cheryl D. Wise > WiserWays > Office: 713.353.0139 > Mobile: 713.412.0406 > [EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002 ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
