Home >  Books > Oracle Discoverer Handbook > Entity Relationship Model

Data model for Global Widgets

This is the model for the tutorial database that is used in all of the Discoverer books.

As you can see, there is a many to many relationship between the GS SALES table and the GS DAY table.  This is because there are four dates in the sales table, a cancelled date, order date, requested date and scheduled date.  When these are modeled in Discoverer these four dates become four complex folders.