Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lucasstark
Starting Member
2 Posts |
 Posted - 2008-09-19 : 19:38:42
|
| I need to figure out the best way to represent the following curriculum information in a nice normalized structure. I have a curriculum DB for a college. Each Major has a list of required courses. That's the easy part. The part that I am seeking guidance on would be how to best represent a requirement when that requirement is an OR or an AND requirement. For instance the following line items need to be represented in the DB. Each line represents a different requirement for the Major. CST-133 OR CST-134CST-155 AND CST-167(CST-101 AND CST-102) OR (CST-201 AND CST-202)CST-144I can't seem to put my finger on the best solution to represent this data in a normalized format. The course number (CST-133) represents the primary key of the courses table. Thank you, |
|
|
lucasstark
Starting Member
2 Posts |
Posted - 2008-09-20 : 06:00:11
|
| Do you think that XML might be the best way to store this data? |
 |
|
|
|
|
|
Curriculum Database