Heterogeneous Data Problems

Rental Program Version 1

Heterogeneous databases include derived tables from a base table to reflect inheritance hierachies in the class structure of a program. A rental company may have an application with the following class hierarchy:



Tables in a Heterogeneous Database


The Customer table is standard.


The Rental table is the master table for all rental entries. Customer id is foreign key. Type is a field to designate rental type: 0 = apartment, 1 = office


The Apartment table contains apartment information.


The Office table contains office information.



Note: the rental programs also rely on smart pointers defined as typedef definitions in Rental.h.