1. Using your knowledge of the way a typical business functions, suggest typical record structures for each of the following: (a) employee record; (b) stock record; (c) sales ledger customer record;...

1. Using your knowledge of the way a typical business functions, suggest typical record structures for each of the following: (a) employee record; (b) stock record; (c) sales ledger customer record; (d) salesperson commission record.

2. ‘There is no reason for an accountant, financier or any other business person involved with a computerized file-based information system to know about the storage organization of data in files and access methods to that data, only about the nature of the data.’ Do you agree?

3. Explain the terms internal schema, external schema and conceptual schema. Illustrate your answer by reference to the project/employee/department example in Section 8.5.