0

I have tried looking for a entity relationship model using the schema of distributed database but I found diagrams as it:

enter image description here

or I found entity relationship models but they are not using the schema of distributed database like this...

enter image description here

I did next diagram but teacher said me it is not using the Distributed database schema. How can i convert it to istributed database schema?? enter image description here

angel
  • 4,474
  • 12
  • 57
  • 89
  • The entity-relationship model is a conceptual/logical model which does not address and is not influenced by physical distribution. – reaanb May 20 '16 at 16:03
  • but any entity-relationship model could use distrituted database? or do they need a special structure? – angel May 20 '16 at 16:12
  • The entity-relationship model deals with the interpretation and association of pieces of data. Where that data is stored is not part of the model. However, your 2nd and 3rd diagrams are not proper ER diagrams, they model tables which are physical structures and may be affected by physical distribution. However, I'm not aware of a formalized distributed table diagram notation. – reaanb May 20 '16 at 16:22
  • There are quite a few initiatives aimed at solving the DDBS model issue, but I don't think any are described very well at this point. It would be interesting to use something like Visio (because you can define templates) to create a [table] => {distribution model} linkage though. Hmmm..... lol – T Gray May 22 '16 at 14:44

0 Answers0