Hi. I am complete beginner in databases, so please bear with me stupid questions.
I am just doing for fun a simple exercise. A faculty have students and each student have different subjects.
My question is, how to store the different subjects in the db?
I could make up some elaborate system like a field subjects and insert the different subjects id's this student has, separating them with "|"s.
Even though my knowledge in db is terrible limited, this seems to me like a very programming oriented approach. Is this the right way to go about it? If not, what is?