snippetMinor
How do you represent VIEWS in an ERD?
Viewed 0 times
representyouviewshowerd
Problem
Are VIEWS (CREATE VIEW) represented in an ERD? If so, how do you represent them and specify what tables they came from?
Solution
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.
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.
Context
StackExchange Database Administrators Q#21016, answer score: 7
Revisions (0)
No revisions yet.