College Student Enrollment and Course Template

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.