Online Photo Album

This is a ER Diagram example that shows the database design of the Online Photo Album.

Database view is a virtual table that provides the result set of a pre-established query command. This ER Diagram example shows the database design of an online photo album. Besides typical entities like photo, album and member, there is a special shape called <<View>> on the right of the diagram. It is a database view shape developed for the Photo Browsing page. As shown in the database view configuration pane, the database view consists of four columns, extracted from entities Photo and Member. Records are sorted with the (Photo) Title column, and are filtered with their upload dates (> sysdate - 5).

For more details about how to create and edit a database view, please read the ERD user's guide at:

https://circle.visual-paradigm.com/docs/database-design-engineering/database-designers-guide/modeling-database-view/