i'm not asking about the complete code.. but i have no idea how to design it.
it would be nice if someone can explain me in uml diagram..

thanks

Design and implement a simple school grade report system.


1. An administrator can assign a class to an instructor
2. A student can enroll a class
3. An instructor can submit grades for a class he/she is teaching.
4. A student can request for a complete grades report of all courses he/she has enrolled.

You need following basic tables for this report system:
1. Student table that contains all students with following information:
a. Id (key, must be unique within this table)
b. First name
c. Last name
2. Instructor table that has all instructors with following columns
a. Id (key, must be unique within this table)
b. First name
c. Last name
5. A class table has following information:
a. Id (key, must be unique within this table)
b. CourseNumber ( i.e. CS555 )
c. InstructorId
d. Year
e. Term

You need following relationship table:

6. ClassStudent
a. ClassId
b. StudentId
c. CourseNumber
d. Grade
Note: ClassId + StudentId must be unique within this table

You need to design different indices to handle searching this system needs.

Hint: student and instructor have many similarities.

Take a look at SQLite.


:davis: