First page Back Continue Last page Image

Time and Modification Anomalies

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