good morning i have question about ER diagram in my databa

good morning , i have question about ER diagram , in my database design i combined all users types in one table but now i want to draw the ER , can i separate the users like putting entity for customer other entity for seller and so even if i combined them in the database in one table ?

Solution

Yes, sure.

You can separate the users like putting entity for customer other entity for seller and so even if you combined them in the database in one table.

As a general recommendation, always use separate tables for each logical entity, identifying the appropriate columns with correct types, constraints and references. It is better to write simple routines and procedures to access and manipulate the data in the tables without aiming for “dynamic code”.

Thank you.