College Student Enrollment and Course Template

[UnknownJoe]

Hello,
I had a previous post on this topic but wanted to repost using some
different wording (thanks for the help "Beetle", just not getting anywhere at
the moment)

Is there a general template or guide for designing a database that allows
for input of students, programs and courses, AND allows for enrollment of
students into the courses (same courses occur with different dates).

I have the following at the moment:
(1) tblStudents - ID (PK), FName, LName
(2) tblPrograms - ID (PK), ProgramName
(3) tblCourses - ID (PK), CourseName
(4) tblLocations - ID (PK), LocationName

I guess my biggest problem at the moment is the enrollment process and the
preferred or recommended way to do so.

Thanks in advance.

 

[Gina Whipp]

UnknownJoe,

You're going to need an...

tblEnrollments
eStudentID (FK) - relate to tblStudents
eProgramID (FK) - relate to tblPrograms or eCourseID (FK) - relate to
tblCourses
....any other fields...

If the Courses are tied to the Programs then use ProgramID or if the
Programs are tied to the Courses etc... If they are seperate then add
fields eProgramID and eCourseID. I am assuming that LocationID is tied to
the either Course or Program???

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[UnknownJoe]

Thanks Gina for your assistance.

Essientally, each Program (i.e. 10 total Programs) has anywhere from 2 to
50 Courses. I already have all the Programs entered into the DB and do not
need to do much with the Program Table any more.
For each record in the Enrollment table, I basically have to choose the
Course, Location (the Location is not attached to another table aside from
the enrollment table - many of the same courses occur in different locations,
sometimes at the same time), and most importantly, be able to list all the
students who have signed up for the course.

Thanks,

David

 

[Gina Whipp]

UnknownJoe,

Then you should probably add LocationID to tblEnrollemnts. "Call" back if
you need further help...

Your welcome!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[UnknownJoe]

OK, now I think we're getting somewhere.

As a summary, here are my 5 tables:
(1) tblPrograms
(2) tblCourses
(3) tblStudents
(4) tblLocations
(5) tblEnrollments - Enrollment ID, Course ID (FK), Student ID (FK),
Location ID (FK), Start Date, End Date

- all tables, excluding tblEnrollments, have some data entered already. When
I go to create the process for enrolling multiple students into 1 course, how
would I design the form?
(1) Should I simply base the main form on tblEnrollments and select a
CourseID, LocationID, Start and End Date, and then choose one student. Then
create a second record for the same course, location, start and end date, and
then choose the 2nd student (and so on, for all students in that course) -
duplication problem i would assume
OR
(2) Could I use the "Allow multiple selections" property - V2007 - so that I
can have one record of the course with multiple students.
OR
(3) Should I be going a different route?

- I don't need to store any information in the tblStudent regarding which
courses they are or have been enrolled in or in tblCourses regarding which
students have been enrolled currently or in the past - I will query
tblEnrollments for this information if needed at a later time.

This is the part that is confusing me. I am trying to avoid duplication in
tblEnrollments but at the same I would like a easy method to register 5 - 40
students in one course, in a particular location, with a specific start and
end date on one form only.

Thanks again.

 

[Gina Whipp]

I like option 1... seems to fit more with what you are doing. Use the
other tables to create combo boxes on the form for ENrollments to typo
mistakes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm