How to model database views?

[David ODriscoll]

While I understand that EA is not a data modelling tool as such, I am very effectively using it as such.

However I am now considering adding some views to the data model, and am not sure how (or indeed if) this can be done.  There is no stereotype for views.

Does anybody have any suggestions?

[jeshaw2]

I asked the same question back around the middle of January.  I was told that views are not yet supported, but the feature is comming soon.  Until then, I'm using the following technique:

I've added the sterotype <<view>> to the base 'class'. Then I add the view and underlying tables to the model using the 'Table' element on the structure menu.

I use the <<view>> sterotype on the table representing the view.

I use 'dependancy' links from the 'view table' back to the tables that support the view.

A 'realize' link back to the use case for a role actor completes the picture.

It doen't get the code generated for a view, but it effectively communicates my design to my programmers.