The problem A relational database has been created using MYSQL to store details about students' performance. There are four tables in the database: Student, Course, Assessment, and Grade. A student...

1. ) Show the detailed results achieved by a specific student sid= ‘S0001’.
   
   
   
   1. For each course taken by the student, show the course ID, title, name, weighting and mark achieved for each assessment.
   
   
   2. Show the course ID and the student’s final result (weighted average) for each of the courses they have taken.
   
   
   
   

Extracted text: The problem A relational database has been created using MYSQL to store details about students' performance. There are four tables in the database: Student, Course, Assessment, and Grade. A student takes one or more courses. A course may be assessed by coursework assessments and exam. The name and weighting of each assessment component are store in the Assessment table. Students' marks on their assessments are recorded in the Grade table. The database itself is stored on dragon, and the tables can be viewed there. An Entit Relationship model of the database is shown below: Assessment Course 1.* aid {PK} cid {FK} 1..1 cid {PK} has title name weighting 1..1 records 1..* Student Grade sid {PK} 1.* sid {PK, FK} aid {PK, FK} mark 1..1 forename achieves > surname gender