undefined

Row Class Sid# Pid# Test#1 raw Professor Student Name Office# Test#1 extra % Test#1 extra credits Test#1 Total 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 Dan P 80 10 8 Jay 33 5 3 Ed P 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 ONE student has changed his name, what types of anomalies will happen? Why? (c) If only ONE new professor without any student has been added, what types of anomalies will happen? Why? (d) If only ONE new student without any professor has been added, what types of anomalies will happen? Why? (e) If all the professors of ONE student are removed, what types of anomalies will happen? Why? (f) If all the students of ONE professor are removed, what types of anomalies will happen? Why