Building Strong Relationships Page 2
These types of relationships are resolved by an associative entity, also known as a cross-reference table or intersection table.
following model will show how to resolve Orders to products.
As you can see, the proper way to handle a many to many relationship, assuming a logical model in 3NF, is to break the relationship down into a series of one to many relationships.
following example shows Customers to Products.
Customers may have many orders, but each order belongs to one customer. Orders are required to have one or more order details, and each order detail may belong to only one order. Each order detail may have only one Product, and products may appear on zero, one, or many order details.
IT Solutions Builder TOP IT RESOURCES TO MOVE YOUR BUSINESS FORWARD
Which topic are you interested in?
What is your company size?
What is your job title?
What is your job function?
Searching our resource database to find your matches...