Does anyone how to draw many to many relationship diagram in Enterprise
Manager? It only allow me to draw one to many, but does not allow me to dra
w
many to many relationship.
Thanks!A many-to-many relationship in a relational model requires an intersection
table. For example:
People --> AssignedRoom <-- Rooms
AssignedRoom handles the intersection of many people assigned to many rooms,
with some being assigned to the same room.
RLF
"she" <she@.discussions.microsoft.com> wrote in message
news:65D409AD-1FC2-4ADB-8DB3-A61F7B6D1A80@.microsoft.com...
> Does anyone how to draw many to many relationship diagram in Enterprise
> Manager? It only allow me to draw one to many, but does not allow me to
> draw
> many to many relationship.
> Thanks!|||Thank you, Russell.
"Russell Fields" wrote:
> A many-to-many relationship in a relational model requires an intersection
> table. For example:
> People --> AssignedRoom <-- Rooms
> AssignedRoom handles the intersection of many people assigned to many room
s,
> with some being assigned to the same room.
>
> RLF
> "she" <she@.discussions.microsoft.com> wrote in message
> news:65D409AD-1FC2-4ADB-8DB3-A61F7B6D1A80@.microsoft.com...
>
>
Thursday, March 29, 2012
Draw many to many relationship diagram
Labels:
database,
diagram,
draw,
enterprisemanager,
microsoft,
mysql,
oracle,
relationship,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment