Referential Integrity (RI) is often used to update tables without human intervention. Would this be a good idea for reference tables?
A.
Yes, since Standards Bodies typically supply reference data, the enterprise can automatically update when a new code or value is received
B.
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
C.
Yes, you do not have to worry about archived data with reference data so tables can be updated automatically
D.
No, but an enterprise can use program logic to do updates as there is little potential for problems to occur with reference data
E.
Yes, older transactions do not have to be removed because with the Cloud there is unlimited database storage
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit