
------------------------------------------------------------
-- Sichten
------------------------------------------------------------

-- a view that shows all current reservations; 


-- a view that shows all reservations, together with the names of the
-- reserving member, the licenseplate, make and model of the reserved car,
-- and the home location of the vehicle; 


-- * a view that shows the locations together with the number of cars at
-- this location and the number of members having this location as their
-- home location


-- the "outer" member table---this is a view showing all attributes
-- of all tables in the member specialization hierarchy; 


-- * the "outer" vehicle table---this is a view showing all attributes 
-- of all the tables in the vehicle specialization hierarchy; 


-- look at the *_JT tables for vehicles, where the 
-- specialization hierarchy has been implemented with foreign keys.
-- Define the VanV view showing all the attributes for Vans (i.e.,
-- including the inherited ones). 

-- look at the *_JT tables for members, where the 
-- specialization hierarchy has been implemented with foreign keys.
-- Define the PersonMemberV view showing all the attributes
-- for PersonMembers (i.e., including the inherited ones). 


-- try to insert new tuples into those views from the previous
-- exercise. What happens? 

