Since no Instructors or students should be assigned to class that no longer exist there should be no real time Modification Anomaly
But what about the Tables holding the Grades? They now reference courses that no longer exist
Courses Table |
||||
courseId |
name |
dept |
cnumber |
description |
013345 |
Intro to Linux |
IT |
135 |
Full description |
013346 |
Cobol Programming |
IT |
089 |
Full description |
courseId |
facid |
stdid |
term |
grade |
013346 |
0017 |
2210 |
20W |
A |
013346 |
0017 |
2211 |
20W |
A |
facid |
fname |
lname |
0017 |
Heather |
Harper |
0018 |
Ian |
Inverness |