NDA-30007 Revision 3.0 Page 9
Conference Room Scheduler Installation Guide Database Requirements
Chapter 3 Database Requirements
Conference Room Scheduler requires three databases (i.e., Conference Room,
Employee Identification, and Reservation). Two of these databases need to be
constructed and thereafter maintained through the APM; the third database (i.e.,
Reservation) is built by Conference Room Scheduler itself while it is running.
Databases are created through the Database Administration option on the APM
System Administration Menu. Database creation involves the following 4-step
process for
each of the two required databases:
1. Create a Master Definition File: This step involves creating the master defini-
tion file that defines the fields in the master database file. Generally one master
definition file parents databases for several applications. Conference Room
Scheduler, however, requires two separate sets of files, one for the conference
room data and one for the employee identification data.
2. Build a Master Database File: This step involves entering data (e.g., confer-
ence room numbers and number of people accommodated) into the master da-
tabase fields that were just defined in Step 1.
3. Create an Application Definition File: In this step, a definition file is created
which defines how data from the master files is to be converted to meet the
needs of Conference Room Scheduler. The database names in the application
configuration file (
crminfofil
and
crmidfile
) must be used for these definition
file names.
4. Process the Application Database: In this step, the Master Database input is
converted to database files according to the definitions created in Step 3, using
the Process/Install Application Databases option on the APM Database Admin-
istration menu. When the Process command is activated, data is drawn from the
master database and converted to the formats specified in the corresponding ap-
plication definition file. The Install command is then activated to enable Con-
ference Room Scheduler to access the database.
Step 1 –
Create
Master
Definition File
Step 2 –
Build
Master
Database File
Step 3 –
Create
Application
Definition File
Step 4 –
Process
Application
Database