Databases Reference
In-Depth Information
provided to the test team before shipping the new release. Thus we want to make sure that the list can be
generated easily and will be included in the release notes for the current iteration or the final release.
The Sample Application
In the following sections we will discuss our approach based on a simple sample application. It is a
facility management application in which you can schedule and topic resources (computers, rooms,
cars, etc.) at different locations.
The tables are stored in the Oracle database in the schema
FM
. All tables are prefixed with the
application prefix
FM
and written in plural (
FM LOCATIONS
instead of
FM LOCATION
). You will find a short
description of the data model in Table 9-1 and the physical data model in Figure 9-1.
Within APEX we will use the application “Facility Management,” having the application id 100.
Table 9-1.
Tables of the Sample Application
Table
Description
FM BOOKINGS
The actual bookings of resources at the different locations
FM COUNTRIES
Countries in which the company operates
FM LOCATIONS
Locations at which the company operates
FM RESOURCE TYPES
Resource types, e.g., computer, vehicle, room
FM RESOURCES
Actual resources (computers, cars, rooms) that can be booked
FM USERS
Table to store the user accounts which are administered in the application
