[RESOLVED] Designing Relational Database

[obrienkev]

I want to create a webpage where students sign up to register for a course.

The student fills out the following form details:
name, id, and selects a course from a select menu.

How should I design a relational database to best suit this.

At the moment I have these tables:

student {name, id} id is the primary key
course {course_ID, course} course_ID is primary key
details {course_ID, id} - links student table and course table

Is there a simpler way of doing this?

Thanks,

Kevin.

[Grisu]

if you want to have one student having different courses, that is correct. If you have a 1-1 relation between student and course (one course per student, each student has a course), you can put the course-id in the student-table