For example, I have 5 courses, MATH101, MATH201, MATH312, HIST412, CSCI320.
- MATH101 has no prereq's
- MATH201 has MATH101 as prereq
- MATH312 has no prereq's
- HIST412 has no prereq's
- CSCI320 has (MATH201 AND MATH312) OR (HIST412) as prereq's
How could this be stored in a database? There could be multiple courses within each AND along with multiple instances of the XOR. I'm pretty stumped as to how to store this.
Here's something that I found on it, but he didn't truely answer the question.
If anyone has any ideas, I would appreciate it.