Database design for a school system - Code Review Stack Exchange
https://codereview.stackexchange.com/questions/418/database-design-for-a-school-system
Jan 30, 2011 · You don't want to allow multiple users/areas/subjects with the same name, thus you must add Unique Constraints on User.username, Area.name, Subject.name, Subject.Abbreviation, etc. The ID in SubjectGrade is useless, it's never used/referenced, the logical key is IDGrade,IDSubject. Similar for ScoreRecord: IDSubject, IDStudent instead of ID
DA: 67 PA: 90 MOZ Rank: 27