Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • How would your schema change if each user (as identified by a single username/password credential set) can access only a single app? It might be that the term "User" is used with different meanings (as in, a set of credentials and the person accessing the system). Commented Nov 2, 2018 at 7:45
  • I'm not sure if I understand your question. If a user only has access to one app, that would be reflected on the app_access table. Commented Nov 2, 2018 at 13:12
  • What I mean is that it might be possible to ignore the fact that user john in app1 and user john in app2 might refer to the same person. You might be able to treat those accounts as completely separate and independent and that might simplify your design. You will have to check with the author of the requirement if this simplification is possible. Commented Nov 2, 2018 at 15:23
  • Don't you think that the profile related to the user defines who that person is? I can't see how ignoring that fact (ignoring the profile relation) could simplify the model. Or you may be refering to other thing and I'm not understanding. Commented Nov 2, 2018 at 16:11
  • Oh, now I understand. You mean that I could have a repetead pair of credentials for the person John and add an app_id to the users table making tihs a users<--N:1-->apps? Commented Nov 2, 2018 at 16:14