Now, there is only one-to-one relationship between users and clients, employees and users. Here are the following entities without relationship yet defined: But not all employees are required to be users of the system.All users are only limited to employees and clients.I figured that it is best to have a single table for users of the system rather having the username and password fields be found in both tables of clients and employees. Since they have different information, I decided to treat them as different entities. The two entities that can access the system are the clients and employees. I am unable to choose between two workable solutions as the best solution as I wish to embrace the best standards. ![]() ![]() I am currently designing an ERD for a project management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |