Book a Demo

Author Topic: Should i create a calss to map 2 bridging DB table  (Read 2505 times)

peter king

  • EA User
  • **
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Should i create a calss to map 2 bridging DB table
« on: March 04, 2010, 11:32:04 am »
Hi friend,

i have received an ERD model of a database that has teh following reltionships between tables: tblAddresses, tblSupplierAddresses, tblSuppliers....

The relationship between the tables tblAddresses and tblSuppliers is M:N therefore tehy have added a bridging table tblSupplierAddresses..

when i create the UML diagram by looking at the ERD diagram, what shoul i create for this bedging entity, should i create a seperate class in teh UML as SupplierAddress to map to tblSupplierAddresses?

thanks

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Should i create a calss to map 2 bridging DB t
« Reply #1 on: March 04, 2010, 08:12:10 pm »
Peter,

It depends on what you are modelling.
Do you want a database model then yes create the linktables.
If you want to create a "logical" entity model then you should just create the m-n associations between the actual entities.

Geert