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”…
local.debbie/finance/sequester-could-lead-to-more-start-ups
local.debbie/finance/asian-stocks-rise-most-in-7-months
local.debbie/finance/new-tax-laws-will-impact-small-businesses
…when they would be better groups like this…
local.debbie/finance/economy/sequester-could-lead-to-more-start-ups
local.debbie/finance/markets/asian-stocks-rise-most-in-7-months
local.debbie/finance/taxes/new-tax-laws-will-impact-small-businesses
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 SECTION -||-----|<- SECTION_ARTICLE ->|------||- ARTICLE
(2) SECTION -||-----o|- SUB-SECTION
(3) SUB-SECTION -||-------|<- SUB-SECTION_ARTICLE ->|----------||- ARTICLE[/INDENT]
Questions:
[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… :-/
Sincerely,
Debbie