set role u3952239_CourseManagers;

--select * from bob.AssignmentSummary;
--select * from bob.Tutorial;
--select * from bob.AssessmentItem;
--select * from bob.Student;
--select * from bob.Mark;

--delete from bob.Mark
--where StudentId = 2010999
--and AId = 'a3';

--select * from bob.Mark;

select * from bob.FinalMark;

update bob.Mark
set AMark = 82
where AId = 'exam'
and StudentId = 2010123;

select * from bob.FinalMark;