When the secretary tries to add data of newly registered contestants into the tblContestants table, an error message is displayed when she enters a value into the School_ID field.
(a) Select the type of error that occurs in this case from the given list below. Write only the letter (A–C) as your answer:
A-Update anomaly
B-Insert anomaly
C-Delete anomaly
b)What needs to be done to be able to register the new contestants that cannot be registered currently?