I am designing a database schema for a web application. Its a first time I am designing a database with a commercial aim. I have started with drawing E-R diagrams after going through requirements phase.
My question is regarding conditions in schema.
I have a table category and sub category with one to many relationship between them. One category has many sub categories.
==================== | Category Name | ==================== | category1 | | category2 | ====================
Sub category Table
=========================================== | Owner Category | Sub category name | =========================================== | category1 | subc1 | | category1 | subc2 | | category2 | subc3 | | category2 | subc4 | ===========================================
Now a user has access to
subc1 if he has access to
Is there any way to depict this scenario with E-R diagram so that by looking up diagram one can know this constraint?
Basically I want to know how this access constraint is propagated to next phase of designs.