I felt this is the best place to ask this, rather than Stackoverflow as it is not related to programming.
Ok. The thing is I need to draw an ERD of a leave management system. Suppose there are three level of user roles there - Level A, B and C.
Where A can manage both B and C; B can manage only C and C is normal users.. Now I've specified an entity named USER in the ERD and thus have to maintain only one table in my database for all type of users and set a role flag and code according to that. But how exactly do I represent this three levels of users in an ERD, as the ERD has only one entity for USER? and role is just an attribute there?
Do I have to make three entities for three types of users and hence create three tables and continue like that? But I can manage all the functionalities with just one table and one flag.
Am a bit confused. Please do guide me. :)