Presenting the Storefront Schema
The schema used for the course application is a subset of the Fusion Order Demo (FOD) schema. You can read about how to obtain the Fusion Order Demo in Section 2.2 of the Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework 11g Release 1 (11.1.1).
The main tables that are used in the course application are Persons, Suppliers, Orders, and Order Items. The application also uses some views, such as Products and ProductCategories.