• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

one to one or many to one ?

 
divya kundapur
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a User table

Column Name
ID (PK)
NAM
ROLE_ID (FK)
GRP_ID (FK)
EMAIL_ID

I want to know will this user table have many to one relationship with role and group table or is it one to one.. the other conditions are below

1 User cannot be present in more than 1 group.
1 User cannot have more than 1 Role.
 
Aaron Liu
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
many to one
 
divya kundapur
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very muchhhhhhhhh
 
divya kundapur
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

why cant it be one to one. I m confused
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic