Small College uses traditional file processing to keep its records. The files used by the Payroll and
Question:
Small College uses traditional file processing to keep its records. The files used by the Payroll and Personnel Departments are shown on the last page of this handout
a. Carefully study the actual data stored in the files – do you see any problems or errors? Give at least three concrete examples (scenarios) of problems that could arise at Small College when these files are used or updated. (Your examples should refer to specific records that are stored in the given files.)
b. Convert the two separate file systems into a unified database
c. Explain why a database would overcome the difficulties that you have listed in part (a).
d. Specify at least four constraints on the data stored in the new database that you have designed in part (b). For each constraint, specify whether it is an integrity constraint, a referential integrity constraint, or a key constraint. You should have at least one example of each type of constraint.
e. Give examples of three informal queries and two updates that could be applied to the database you have designed.
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood