(13) Define data independence?

QUESTION: Define data independence?   [signinlocker] SOLUTION Data independence occurs as a result of the conceptual schema insulating user views (i.e., the external schema) from changes in the physical storage structure of the data in the internal schema. This is also known as physical data...
Continue reading »

(5) Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?

QUESTION: Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?   [signinlocker] SOLUTION Printing monthly (weekly, bi-weekly) payroll checks is the classic example since typically, virtually every employee receives a...
Continue reading »