undefined

Row Class Sid# Test#1 Pid# Professor Office# Student Name Test#1 raw Test#1 extra % Test#1 extra credits Total 1 1 AIC 10 5 55 2 Gauss 22 2 1 2 Bob B 60 10 6 66 2 Gauss 22 3 2 3 Cal T 70 10 77 3 Jay 33 2 4 Dan P 80 10 8 3 Jay 33 5 3 5 EdP 10 3 Jay 33 6 3 3 Cal T 10 99 3 Jay 34 The table is from a file has a record of all student's information including name, Id, scores and their assigned professor for each class. 1. For each of the following scenes, use the table to demonstrate what type of data anomaly may occur: (a) If ONE professor has changed his office number, what types of anomalies will happen? Why? (b) If only ONE new professor without any student has been added, what types of anomalies will happen? Why? (c) If all the professors of ONE student are removed, what types of anomalies will happen? Why