Create a Grade Book Database

1. Problem Statement

You are asked to implement a grade book to keep track student grades for several couses that a professor teaches. Courses should have the information of department, course number, course name, semester, and year.  For each course, the grade is caculated on various categories, including course participations, homework, tests, projects, etc.  The total percentages of the categories should add to 100% and the total perfect grade should be 100. The number of assignments from each category is unspecified, and can change at any time.  For example, a course may be graded by the distribution: 10% participation, 20% homework, 50% tests, 20% projects. Please note that if there are 5 homework, each homework is worth 20%/5=4% of the grade.

¡¡

2. Tasks

  1. Design the ER diagram;
  2. Write the commands for creating tables and inserting values;
  3. Show the tables with the contents that you have inserted;
  4. Compute the average/highest/lowest score of an assignment;
  5. List all of the students in a given course;
  6. List all of the students in a course and all of their scores on every assignment;
  7. Add an assignment to a course;
  8. Change the percentages of the categories for a course;
  9. Add 2 points to the score of each student on an assignment;
  10. Add 2 points just to those students whose last name contains a ¡®Q¡¯.
  11. Compute the grade for a student;
  12. Compute the grade for a student, where the lowest score for a given category is dropped.

¡¡

3. Your submission

  1. The ER diagram (with the attributes and foreign keys/primary keys indicated);
  2. The commands for creating tables and inserting values (task 2);
  3. The tables with the contents that you have inserted (task 3);
  4. The command that you use to get task 4, 5, 6, 7, 8, 9, 10, 11, 12;
  5. The source code;
  6. A README file. The minimum required content of the file should contains the instructions to compile and execute your code;
  7. The test cases that you use and the results that you get from the test cases.

¡¡

Grading rubrics (total possible points is 100):

¡¡