Query for Topping content is basically
select id, name, color
from (select * from option where
kind=1)
join
topping on <unique key match>
Query for Option content:
select … from
option left outer join topping on <unique
key match>
These could be the bases
of updatable views in the database:
the FKs are there