Hello
I've being struggling with designing a MS Access Database Schema. It is for a Category Tree with 4 Category Levels. What is making it difficult is that and Category Level can be linked to any Category one level higher.
For example;
Computing, Electronics, IT & AVI >> Networking >> Physical Security >> IP Cameras
Computing, Electronics, IT & AVI >> Audio, Video & Image >> Digital Cameras & Video >> IP Cameras
See how IP Cameras is linked to both Physical Security and Digital Cameras & Video.
What I have done is setup a table for Levels, then a table for Categories and finally a table for Category Groups.
The fields in table for Levels are;
Level_ID
Name
Description
The fields in table for Categories are;
Cat_ID
Name
Description
Level_ID
The fields in table for Category Groups are;
Cat_Group_ID
Cat_Level1_ID
Cat_Level2_ID
Cat_Level3_ID
Cat_Level4_ID
So just in case it is not clear the Cat_Level1_ID, Cat_Level2_ID, Cat_Level3_ID, Cat_Level4_ID field are bound to Cat_ID
My first question is the following. Is this the correct table structure to use or would there be a better method. Like having different Category Level Link Groups? Level 1 to Level 2, Level 2 to Level 3 and so on.
Thanks
I've being struggling with designing a MS Access Database Schema. It is for a Category Tree with 4 Category Levels. What is making it difficult is that and Category Level can be linked to any Category one level higher.
For example;
Computing, Electronics, IT & AVI >> Networking >> Physical Security >> IP Cameras
Computing, Electronics, IT & AVI >> Audio, Video & Image >> Digital Cameras & Video >> IP Cameras
See how IP Cameras is linked to both Physical Security and Digital Cameras & Video.
What I have done is setup a table for Levels, then a table for Categories and finally a table for Category Groups.
The fields in table for Levels are;
Level_ID
Name
Description
The fields in table for Categories are;
Cat_ID
Name
Description
Level_ID
The fields in table for Category Groups are;
Cat_Group_ID
Cat_Level1_ID
Cat_Level2_ID
Cat_Level3_ID
Cat_Level4_ID
So just in case it is not clear the Cat_Level1_ID, Cat_Level2_ID, Cat_Level3_ID, Cat_Level4_ID field are bound to Cat_ID
My first question is the following. Is this the correct table structure to use or would there be a better method. Like having different Category Level Link Groups? Level 1 to Level 2, Level 2 to Level 3 and so on.
Thanks