The tables below list student/subject, department number, and enrolment data. Each student may enroll in many subjects f

[answerhappygod]

The tables below list student/subject, department number, and
enrolment data. Each student may enroll in many subjects from
various departments in a university. Subjects are offered by
different departments.
SubjectNo
SubjectName
DepartmentNo
1122
Database I
D100
1123
Chemistry II
D88
1124
Biology II
D12
1124
Biology II
D12
1199
Chemistry I
D6
1199
Chemistry I
D6
StudentName
EnrolmentDate
Enrolment fee
SubjectNo
StudentNo
J. Smith
14/2/2016
$1200
1122
u100
P. Ross
17/2/2011
$1200
1123
u201
J. Smith
16/2/2016
$1100
1124
u100
K. Lee
14/1/2013
$1100
1124
u313
J. Smith
20/1/2016
$1000
1199
u100
T. Khan
20/1/2010
$1000
1199
u295
(a) The data in the above table is
susceptible to update anomalies. Provide examples of how insertion,
deletion, and modification anomalies could occur in the above
tables.