Database design is a huge topic that is well beyond the scope of this book; however, there are some database design issues that must be considered when APEX is used as the primary GUI for managing data in an Oracle database. Some key observations related to database design in an APEX context are:
APEX lives inside the Oracle database, not in a mid-tier application server.
APEX itself is a database application that is written primarily in PL/SQL.
APEX applications are described by metadata that are stored in rows and columns in database tables; they are ...