Are VIEWS (CREATE VIEW) represented in an ERD? If so, how do you represent them and specify what tables they came from?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
There is a view object available in several ERD tools that I've seen (TOAD, Agilian, Visio). I'm not entirely sure that it is formally a part of any notation, but could be construed as a stereotype, as it is effectively just another entity.
Demonstrating the relationship to the source tables is a bit more difficult, IMO. I would just use a generic connector, especially as the relationship is likely much more complex than can be described visually (I just created a view that is populated in part by functions that run complex queries on multiple tables). I would absolutely not use the relationship connectors.