The tables below list student/subject, department number, and enrolment data. Each student may enroll in many subjects f
Posted: Fri May 20, 2022 12:50 pm
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.
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.