As stated in an earlier thread, I want to add the concept of "Sub-Sections" to my website.
Currently, I have articles just grouped by Section (e.g. Finance) which doesn't give me a lot of control with the UI or back-end. For example, I might have the diverse articles all lumped together under "Finance"...
...when they would be better groups like this....
So here is the data model that I have come up with...
[INDENT]One SECTION has one or more ARTICLEs
One ARTICLE has one or more SECTIONs
One SECTION has one or more SUB-SECTIONs
One SUB-SECTION has one or more ARTICLEs
One ARTICLE has one or more SUB-SECTIONs[/INDENT]
And using Crow's Foot Notation...
[INDENT](1) SECTION -||-----|<- SECTION_ARTICLE ->|------||- ARTICLE
(2) SECTION -||-----o|- SUB-SECTION
(3) SUB-SECTION -||-------|<- SUB-SECTION_ARTICLE ->|----------||- ARTICLE[/INDENT]
[INDENT]1.) To do things like validating URLs and storing data, do I need relationship #1?
(It seems like Relationship #1 and #3 are almost redundant?!)
2.) Do I just care about the end relationship between an Article and it's Sub-Section, or do I need to care about the relationship to the parent Section?
3.) Anything I need to take care of or should be concerned about?[/INDENT]
I just don't feel very confident in what I am doing here... :-/