Question 1.

Read Accessed: B_A3Student, B_AssessmentItem, B_Mark
Write Accessed: none

Users making transaction: Course Managers
Input values required: none

SQL statements:

select M.StudentId, Surname, FirstName, sum(FinalPercent*(AMark/TotalMark)) as Final_Mark
from Student S, AssessmentItem A, Mark M
where M.AId = A.AId
and M.StudentId = S.StudentId
group by M.StudentId, Surname, FirstName
order by Final_Mark desc;


Question 2.

Read Accessed: Tutorial, Student
Write Accessed: none

Users making transaction: Course Managers
Input values required: TutId

SQL Statements: ?? Actual query or just the statements ??

select StudentId, Surname, FirstName 
from Tutorial T, Student S
where T.TutId = '&TutId'
and T.TutId = S.TutId;


Question 3.

Read Accessed: Mark, Student, Tutorial
Write Accessed: Mark

Users making transaction: Tutors
Input values required: TutId

SQL Statements: