) Show the detailed results achieved by a specific student sid= ‘S0001’.For each course taken by the student, show the course ID, title, name, weighting and mark achieved for each assessment.Show the course ID and the student’s final result (weighted average) for each of the courses they have taken. The problemA relational database has been created using MYSQL to store details about students'performance. There are four tables in the database: Student, Course, Assessment, andGrade. A student takes one or more courses. A course may be assessed by courseworkassessments and exam. The name and weighting of each assessment component are storein the Assessment table. Students' marks on their assessments are recorded in the Gradetable. The database itself is stored on dragon, and the tables can be viewed there. An EntitRelationship model of the database is shown below:AssessmentCourse1.* aid {PK}cid {FK}1..1cid {PK}hastitlenameweighting1..1records1..*StudentGradesid {PK}1.* sid {PK, FK}aid {PK, FK}mark1..1forenameachieves >surnamegender

Given Show the detailed results achieved by a specific student sid= ‘S0001’. For each course…

Answered: Show the detailed results achieved by a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

) 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.

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions