Identify the data redundancy from the following spreadsheet and provide examples of Update Anomaly, Insert Anomaly,...

Transcribed Image Text:

Identify the data redundancy from the following spreadsheet and provide examples of Update Anomaly, Insert Anomaly, and Delete Anomaly. Employee Hire Date Mary John David 011101990 10182000 05302004 Manager Alice Alice Tony Manager Salary 80,000 80,000 90,000 ... NOTE: 'Manager' is the manager of that employee. An employee can have only one manager. Σ Identify the data redundancy from the following spreadsheet and provide examples of Update Anomaly, Insert Anomaly, and Delete Anomaly. Employee Hire Date Mary John David 011101990 10182000 05302004 Manager Alice Alice Tony Manager Salary 80,000 80,000 90,000 ... NOTE: 'Manager' is the manager of that employee. An employee can have only one manager. Σ

Answer rating: 100% (QA)

Answer Data Redundancy Manager name and Manager salary data are redundant in the table Update A... View the full answer