Re: Entering Data

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.


--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:06554C64-A8FA-483A-B9A3-C5B31D09EF77@xxxxxxxxxxxxxxxx
> 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.


.

Relevant Pages

  • Re: Setup Tables
    ... Students don't enrol in a course: they enrol in a course instance. ... BTW, there's a *lot* of work in setting up a database like that, tracking students, lecturers, government departments, courses, course instances, the units that make up the course, the instances of those units, the unit coordinators, class dates, attendances, assignments set, assignments submitted, exams, results achieved in assessments, results for the subjects/units, certificates/qualifications issued, fees due, fees paid, applications and enrolments, documentation, interactions with students, handling specific issues, and the like. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Setup Tables
    ... The database has about fifty tables, hundreds of querys, many ... I have spent over two years adding functionality. ... Students don't enrol in a course: they enrol in a course instance. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: User Supplied Parameter Query
    ... On the query, I've tried your code, but now I only get the data back if all 4 ... Classes].Attended, [Students And Classes].Cancellation, Students.BU ... > Would you ever have a case where a student didn't enroll and didn't attend ... > and didn't cancel? ...
    (microsoft.public.access.queries)
  • Re: (NBC) Globalization Backlash in Rich Nations
    ... Our school district spends a lot of money on this school. ... finding students who want to study nursing, auto-tech, building trades, etc. ... Many of the students who enroll in the vocational classes are sub-standard ...
    (rec.music.artists.springsteen)
  • Re: Optics Education
    ... My university had a program at one point under which students could ... enroll toward an MS degree without having a BS degree first, ... engineering and math courses they still needed as preparation ...
    (sci.optics)