I'm looking for an answer to a question regarding attributes.
Can an attribute be shown on an ER diagram as one that has to be indicated by the user whether it is to be made visible or not. This is for a social media DB.
My thoughts were that possible a recursive relationship could do the job. Such as from the entity MEMBER and the relationship (Makes_public) but I dont think that would work as each side is meant to have a role.
Has anyone had any experience with this problem before ? or any ideas?
So I would have the MEMBER table with all attributes made public regardless then a relationship with another table with attributes such as relationship status.. and the boolean attribute would be in the MEMBER table and when true would indicate the other table was to be public? is that right ?
If so what if the user only wants their some details made public and not the others?