I am trying to create a database to store information regarding equivalent courses transferring from one school to another. I am struggling to conceptualize the relationship in a way that can translate into a database. I currently have two tables, each holding the courses offered by each school. These tables contain the course code, the course name, the course description and the number of credit hours.
School 1 offers courses A, B, C, D. School 2 offers courses W, X, Y, Z.
The equivalent courses could be:
A = W --Taking class A at School 1 is equivalent to taking class W at School 2.
A+C = Y --Taking classes A and C at School 1 is equivalent to taking class Y at School 2.
D = X+Y+Z --Taking class D at School 1 is equivalent to taking classes X, Y and Z at School 2.
And so on. One or more classes at School 1 will be equivalent to one or more classes at School 2. Every course from School 1 needs to have an equivalent course at School 2, as there is a "General Elective" catch all. However, not every course at School 2 will be represented.
I'm not extremely technical and am more interested in just design at this stage. Any help is greatly appreciated.