Grade level table and subjects table

[Khalil Handal]

Hi,
I have a table showing grade levels (tblGradeLevels) and another table showing the subjects (tblSubjects). Each grade level has certain subjects.
How can have a table showing each grade level with its corresponding subjects?
Some subjects are common for all grade levels and others are not.


The goal is to select a grade level, a certain subject and all students will be shown so as to enter grades for them.

Thanks in advance

[ranman256]

you have tblGradeLevels and tblSubjects
and you will need tblGradeSubjs:
GradeSubjID
year
grade
Subject
ClassTime

to hold the subjects for each Grade.

then you will prob want
tblRoster tbl
GradeSubjID
StudentID
FinalGrade

etc

[orange]

Khalil,

Here are some free videos that you may find helpful with Database and Design.
Intro to Database
The Relational Model
Data Modelling and the ER Model

Good luck

[Khalil Handal]

Thanks to both,
I will look at the videos and try your suggestions

Khalil

[Khalil Handal]

Hi,
How would the relations be between the tables?
The tables are as follows:
tblStudents, tblGradeLevels, tblSubjects, tblGradeSubjs, tblRoster

Khalil