The figure shows the horizontal storage model, in which each view or subview is based on a different table.
The tables are only_person
, only_students
, and only_employees
. The Person_v
view is based on the only_person
table, the Student_v
view is based on the only_students
table, and the Employee_v
view is based on the only_employees
table.
The tables all contain person attributes. In addition, only_students
contains student attributes and only_employees
contains employee attributes. The views contain the same attributes as the underlying tables.