Grade Book Database This is supposed to develop a database to manage a grade boo

Question

Grade Book Database

This is supposed to develop a database to manage a grade book. Your product should contain information about courses, students, grades for homework, quizzes, midterm, ?nal, and various grades.

Each course has id, title, credit hour.

You should store an id, name, email for each student.

Each homework has number, submission date and time, due date, marks.

Each quiz has number, marks, date.

You have to store also number and marks for the exams (midterm and final).

Students enroll to courses and you have to store their final grade.

Database should also store the various activity grades for each student.

SQL Queries:

1.         Find all students who are taking “math” course along with their grades in mid and final exam.

2.         Find the students who submitted a homework after the deadline in “biology” course.

3.         Find the quizzes of “math” course along with their dates and marks.

4.         Show the total grades of each course that a student has taken.

5.         Show the students who obtained grades less than 60 in “physics” course.

my qustions are in relation schema do I have to add SID in the three (homework, quiz and exam) as a foreign key or SID in the coruse is enough? also, is the ER digram and relation schema in the below two snapshot are correct? is the schema need to normilazation?

Explanation / Answer

Create different tables in the database as Student , Course,Hom Homew,Quiz,Exams

No need to add sid as foreign key in any table.

In every table there is a corresponding id column.. for exmplee in student table student_id, in course table course_id in quiz table quiz_id etc.

So all these columns are imdependent i.e are not refered in other tables..so no need of foreign keys..

You can refer student with corresponding quiz , homework or any other attribute in the tables without using foreign keys for this question..

You said you have attached some snapshots but there are no snapshots available in the question...

Hope it helps..

Thank you...

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.