• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

many-to-many relationship

What are the implications of a many-to-many relationship. Why is it best practice to have a bridging to table?

Thanks
0
Mr_Shaw
Asked:
Mr_Shaw
1 Solution
 
EyalCommented:
datatable1
field1(PK)

datatable2
field2(PK)

relationstable
field1(FK)
field2(FK)

we use this design to avoid duplication of data

0
 
Mr_ShawAuthor Commented:
thanks
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now