relational database design question
Posted 12 October 2006 - 06:53 PM
My question is a design question. I understand the basic concept of relational databases, but before I do something completely wrong I wanted some professional feedback.
What I am creating is a database that has several categories and then the important data at the end; in this case, resources.
I will have over 20,000 resources that will be matched up to about 5,000 objectives. EACH resource MAY be valid for MANY objectives. The 5,000 objectives are unique and fit into about 1,000 unique categories called concepts. The 1,0000 unique concepts fit into 200 categories called big ideas. Then another challenge...Those 200 unique big ideas fit into 4 shared categories called "levels". The four "levels" branch up into about 20 unique strands. The 20 strands fit into the broadest categories called subjects. The challenge that I see in the middle there is this. Each strand fits into one subject. The "levels" can exist in any strand or subject; each strand will have the same 4 levels. The big ideas (and so on down the line) really are unique to the level above it, for example concept number 12 only belongs to big idea number 5 (no other big idea), but big idea number 5 has between 2 and 8 concepts.
The only data that will change in the near future is the lowest level (resources) and the objectives that they belong to. There may also be a need to categorize all 20,000 resources into 2 categories like free and requires payment.
How many tables do I need? Do I need thousands? For example, 1,000 different concept tables each containing their unique objectives. How will the final resources fit in? Any description of what I need is greatly appreciated. Thank you!
Posted 12 October 2006 - 07:57 PM
Posted 13 October 2006 - 12:38 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users