Entering Data

[John]

Hi,

I am working on a school database that has many courses and students.

It was working fine until I realized that some students want to enroll into
other courses. I want to avoid typing their information again and again if
they have already taken a course with the school. Basicaly, under the same
name, I want to see their courses taken or enrolled. Any help would be
great. Thank you.

H

 

[Allen Browne]

The crucial thing is that one course may be offered multiple times over the
years, so students do not enrol in a course. They enrol in an instance of a
course.

Something like this:

Student: (One record for each student)
StudentID primary key (pk)
Surname
FirstName
...

Staff: (One record for each teacher)
StaffID pk
Surname
FirstName

Dept: (One record for each dept, e.g. English, Math):
DeptID pk
DeptName Name of the dept.

Course: (One record for each course)
CourseId pk
CourseName unique name for this course
DeptID the department that offers this course.

CourseInstance: (One record for each time a course is run.)
CourseInstanceID pk
CouseId Which course is being offered.
CourseStartDate When this instance of the course begins.
StaffID Who is running this course instance.

Enrol: (One record for each person enrolled in a CourseInstance)
EnrolId pk
StudentId who is enrolled
CourseInstanceId Which course instance they enrolled in.