Add a table that links Students, Modules and Grades. Consider what the key should be (and I
don't mean "StudentModuleGradeID" - see below!)
Some comments:
- Why prefix your tables with "Table_"? Students, Modules, Grades are good table names.
- You don't need to add a surrogate key to every table - in particular, not to the one that links Modules to Programmes, which should have as its key the compound (ModuleID, ProgrammeID), and the new table. You need to think about what makes a row really unique - consider:
Code:
insert into Grades (GradeId, Grade) values (1, 'A');
insert into Grades (GradeId, Grade) values (2, 'A');
insert into Grades (GradeId, Grade) values (3, 'A');
Your design makes that perfectly acceptable data.
dBforums
>
University Database Design (small problem)
12-03-08, 05:24
Linear Mode
