Questions -
The owner of a small family-owned business currently prepares his own payroll manually, but he is considering switching to an AIS. He is skeptical about the security of the information and asked you to educate him about the types of unauthorized changes to payroll data, and explain at least two controls that would maintain the integrity of the payroll master file.
When designing a database, why is it not preferable to store all data in one single table? Why is it better to have multiple separate tables? Give an example of the type of data that would be stored in its own table.