Referential Integrity (RI) is often used to update tables without human intervention.

Yes, since Standards Bodies typically supply reference data, the enterprise can automatically update when a new code or value is received

No, updates should always be made directly via data entry or through a specific batch interface based on operator-entered information partly because of regulatory reporting and archiving

Yes, you do not have to worry about archived data with reference data so tables can be updated automatically

No, but an enterprise can use program logic to do updates as there is little potential for problems to occur with reference data

Yes, older transactions do not have to be removed because with the Cloud there is unlimited database storage