I have a database that has different grades for different courses (i.e. three homework for course 1, for course 2 Two homework). , N. course with M.M. homework). How do I manage it as a database design?
CourseID HW1 HW2 HW3 1 100 99 100 2 100 75 NULL Edit I think I should ask your question Will have to re-write. As of now, I have two tables, courses and homework. Homework indicates curriculum through a foreign key My question is how do I know how many homework will be available for each class?
Subtracting a curriculum in the three separate tables, it has a homework, the second holds homework, and the third Connects to them and stores results.
Course:
CourseID CourseName 1 Foo Homework:
Homeworking Homework Homework Details HW1 times ... Result:
CourseID HomeworkID result 1 hw 1 100 
Comments
Post a Comment