I'm new at database and I have a mini project !
I chose E-learning and made up a case study
I have two design and I don't know which one is better !
My case study is a website that offer a tutorials or what so ever
Each student must reigister to the website at first and they will reseve a rigister id .
Each student must reigister the course they want , they can take nothing or many courses .
Each teacher must teach one course only .
The course can have one or many teachers .
First I have 4 tabels
Try adding a foreign key to the tables and create a physical relationship. Wouldn't there be an fk from teacher to course? This tells us who is teaching the course. A student will take a course so shouldn't there be a fk to course in student take?