Database model advice

[suarve]

Hi,

I need to design part of a data model that allows me to store user selection on courses and I have become slightly stuck. Basically, I need to do a list of all available courses (can do this bit). Each course is made up of several modules (that make up a course - like a university degree with many modules studied) - that can either be compulsory or an option.

My initial thought was to ditch a table having a list of courses and have a table that lists modules. A table would link to this showing the make up of a course E.g.

Modules
*Module ID
Name
Start Date
Etc.

Courses
*Course IDCourse title
Core Module 1
Core Module 2
Option 1
Option 2

(all the options would be FKs to the Modules table)

I'm sure there must be a better way as that database currently isn't in 1NF

I'm really struggling how to design the tables for the latter, can anyone help?

Many Thanks

 

[suarve]

Excellent stuff! Many thanks for the reply.

EDIT: this is probably me being stupid, how would i list the Course with its modules? E.g

Course ID
- Module ID 1
- Module ID 2
- Module ID 3
- opt 1
-opt 2
etc