Model Question# Database - 数据库
C*n
1 楼
Table:
User: UserID,...
Portal: PortalID,...
Role: RoleID, PortalID, ....
UserRole: UserID, RoleID
Question: Is this model 3NF? if not how to change it?
My problem is that: I want to constraint a User should belong to a paticular
portal. But right now, a User doesn't belong to any portal if he doesn't have
any ROLE associated, and I don't want a user has role from more than 1 portal.
Thanks,
Calvin
User: UserID,...
Portal: PortalID,...
Role: RoleID, PortalID, ....
UserRole: UserID, RoleID
Question: Is this model 3NF? if not how to change it?
My problem is that: I want to constraint a User should belong to a paticular
portal. But right now, a User doesn't belong to any portal if he doesn't have
any ROLE associated, and I don't want a user has role from more than 1 portal.
Thanks,
Calvin