Re: Ensuring data integrity
"You've not provided an argument for how a composite PK in members improves privacy."
Maybe not a good argument, but...
The application could take great strides to ensure the user belongs to and is logged onto a given bank account. Or the user belogns to and is logged onto a given companies sales management system. And with that, the bank account ID, or given company's sales management system ID is verified to be accurate. That ID number could them ne included in the PK of associated directly linked tables. Then when other tables are linked, they too will contain the bank account (or company's) ID.
Thank you for any advice.
Michael
Subject
Written By
Posted
Re: Ensuring data integrity
July 30, 2010 10:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.